If Outlook is on at 4 pm then you could set up something with a reminder to run the code.
https://msdn.microsoft.com/VBA/Outlo...-event-outlook
A recurring appointment should be reasonable.
This code for ThisOutlookSession is the simplified version of what is shown in the link.
Untested but this is the idea.
Private Sub Application_Reminder(ByVal appt As Object)
If appt.Subject = "Test - SendMail / any unique appointment subject" then
SendMail
End If
End Sub
You can dismiss the reminder with the BeforeReminderShow event
https://msdn.microsoft.com/VBA/Outlo...-event-outlook