Automatically Send Excel Spreadsheet Daily

  • Thread starter Thread starter Zee
  • Start date Start date
Z

Zee

Is it possible to send an excel spreadsheet daily to an email address at a
specific time e.g 5:00 pm.

Thanks
 
Chip Pearson explains how to use Application.ontime (excel has to be open) here:
http://www.cpearson.com/excel/OnTime.aspx

If you don't want excel open, maybe you can find a windows scheduler that you
like--some versions of windows have one built in.

And if I were going to learn about sending a workbook via excel, I'd start with
Ron de Bruin's site:
http://www.rondebruin.nl/tips.htm

======
Heck, I've never done this, but maybe you can find out how to use your
scheduling program to email the file you want and drop excel completely.
 
Chip Pearson explains how to use Application.ontime (excel has to be open) here:
http://www.cpearson.com/excel/OnTime.aspx

If you don't want excel open, maybe you can find a windows scheduler that you
like--some versions of windows have one built in.

And if I were going to learn about sending a workbook via excel, I'd start with
Ron de Bruin's site:
http://www.rondebruin.nl/tips.htm

======
Heck, I've never done this, but maybe you can find out how to use your
scheduling program to email the file you want and drop excel completely.
 
It is better to do this as an outlook macro. See under VBA help in Outlook

Reminder Event


You can schedule in outlook a daily event for 5A:00 PM. Then when the event
occurs you can attach an excel workbook to an email and sent the email.
 
It is better to do this as an outlook macro. See under VBA help in Outlook

Reminder Event


You can schedule in outlook a daily event for 5A:00 PM. Then when the event
occurs you can attach an excel workbook to an email and sent the email.
 
Back
Top