run a macro at a set time
This works with a reference to excel:
excel.Application.OnTime Now + TimeValue("00:05:00"), "myMacro"
"Rob" wrote:
I want to set a macro to run at a given time.
Application.OnTime 'does this in excel, but I can't find a way in outlook.
any help?
Also, I'd like to be able to pass a parameter to the macro, but that doesn't
seem posible. I'd get round this in excel by putting the parameter in a cell
somewhere, but I don't know where to store it in Outlook.
Thanks in advance
Rob
|