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,

Maybe the event Application.OnTime would be helpful.


-----Original Message-----
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,
.

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"

-----Original Message-----
Maybe the event Application.OnTime would be helpful.


-----Original Message-----
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,
.

.

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



--
Message posted from http://www.ExcelForum.com

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

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

K


---
Message posted from http://www.ExcelForum.com/

.