Automatically Run Macro

C

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,
 
C

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"
 
K

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...
 
C

Carl

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