Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating excel with outlook
Hi,
I am tryiing to setup an automated command within excel for every 1/2 hr to send a column in excel with data to large group of people through outlook. I am using this code but it is not working out: Sub AutoRefresh() ActiveWorkbook.RefreshAll Application.OnTime Now + TimeValue("00:01:00"), "SendEmail" Application.OnTime Now + TimeValue("00:30:00"), "AutoRefresh" End Sub It works only the 1st time when the workbook is open after that for every 1/2 hr it loses 1 min so the next time instead of starting @ 30 min interval, it starts @ 29 min and so on. In the end the schedule email gets delivered earlier and earlier instead of the precise 30 min interval that I am looking for. How can I get it done??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating excel with outlook
I may be wrong, but I don't think you need Outlook to do what you want to do.
Take a look at this: http://www.cpearson.com/excel/OnTime.aspx Regards, Ryan-- -- RyGuy "sjj11" wrote: Hi, I am tryiing to setup an automated command within excel for every 1/2 hr to send a column in excel with data to large group of people through outlook. I am using this code but it is not working out: Sub AutoRefresh() ActiveWorkbook.RefreshAll Application.OnTime Now + TimeValue("00:01:00"), "SendEmail" Application.OnTime Now + TimeValue("00:30:00"), "AutoRefresh" End Sub It works only the 1st time when the workbook is open after that for every 1/2 hr it loses 1 min so the next time instead of starting @ 30 min interval, it starts @ 29 min and so on. In the end the schedule email gets delivered earlier and earlier instead of the precise 30 min interval that I am looking for. How can I get it done??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Automating Excel | Excel Discussion (Misc queries) | |||
Automating Excel w VB.Net 2003 | Excel Discussion (Misc queries) | |||
Excel 97 - automating getting info from web | Excel Discussion (Misc queries) | |||
AUTOMATING JOB SHEETS IN EXCEL | New Users to Excel |