Automatically Run Macro

[Carl]

I am sending a range in a spreadsheet at 5 minutes after
each hour during the day using a macro to send the data
through Outlook. Is there a way to automatically run this
macro at specific times througout the day?

Thank you,

 

[Nick]

Maybe the event Application.OnTime would be helpful.

 

[Carl]

I am trying to use the Application.OnTime method now but
can't get it to work. I am using the following code to
launch the macro:

Application.OnTime
TimeValue "09:30:00"), "Mail_Selection_Outlook_Body"

 

[kkknie]

You could write the code to do the sending in the Workbook_Open even
and then schedule it to run using the Microsoft Scheduler (you woul
exit excel after the code runs). This would only be useful if you d
not need the workbook open at all times...

 

[Carl]

Thank You. I have gotten it started using a combination
of the OnTime method and the Call Statement.