Ontime Method in Outlook

counterindigo · January 21st, 2011, 02:10 PM

Hi,

I have been trying to use the ontime method in outlook and keep getting error 438, Object does not support this property or method. I coppied the code into excel and it works fine. Does anyone know why it would work in excel but not in Outlook?

Thanks

Code:

 'Code placed in UserForm:
Sub TryThis()
    Application.OnTime Now + TimeValue("00:00:15"), "SayHello"
End Sub

'Code placed in Module:
Public Sub SayHello()
    MsgBox "Hello!"
End Sub

JP · September 13th, 2011, 12:13 PM

I know this post is old, but I thought I'd answer anyway. Outlook does not have an OnTime method, but Excel does. That is why it works in Excel but not Outlook.

To simulate the OnTime Method, create a task with a reminder for the time you want the macro to run. Use a unique Subject string for the task. Hook the BeforeReminderShow Event and check for the unique string in the Subject that you specified when you created the task. If it's a match, run the macro you wanted to run at that time. Also, set Cancel = True so the reminder doesn't actually fire (it already did it's job so it doesn't need to actually fire).