Guys Please can you help, im trying to send an automatic email message using VBA - in debug mode the step through works ok, but the timer function i have written does not seem to be called - have i done something wrong?? Here is the code i've written
Thanks
jarvis
Option Explicit
Dim nextTimeCheck As Date
Sub Aut
pen()
Check_Time
On Error Resume Next
End Sub
Sub Check_Time()
On Error Resume Next
If TimeValue(Now()) = TimeValue("15:11:00"
And TimeValue(Now()) < TimeValue("15:12:00"
Then
ThisOutlookSession.Email
End If
nextTimeCheck = Now + TimeValue("00:00:30"
Application.OnTime EarliestTime:=nextTimeCheck, Procedure:="Check_Time"
Aut
pen
End Sub
Thanks
jarvis
Option Explicit
Dim nextTimeCheck As Date
Sub Aut
Check_Time
On Error Resume Next
End Sub
Sub Check_Time()
On Error Resume Next
If TimeValue(Now()) = TimeValue("15:11:00"
ThisOutlookSession.Email
End If
nextTimeCheck = Now + TimeValue("00:00:30"
Application.OnTime EarliestTime:=nextTimeCheck, Procedure:="Check_Time"
Aut
End Sub