Sending DAILY emails from Excel

[yacoucha]

Hi everyone,
I am new board member and need your help on something:

I know how to send an email from excel using VBA, but I would like to know how send an email every day without opening the Excel file continaing the macro. (Let's say I can specify a given time, then, whether the Excel file is open or not, the program would send the mail using the infos from the Workbook)

Would you know if this is possible (because all I could see was 'how to send an email after a change in the workbook') ?

Yacoucha

 

[Smitty]

Welcome to the Board!

If you goto Start-->All Programs-->Accessories-->System Tools-->Scheduled Tasks you'll be at the Windows Scheduler where you can schedule a wb to open at a specific time each day. From there you can use some VBA in the open event to send the wb, then close itself.

Hope that helps,

 

[yacoucha]

Ooooh, I didn't know I could do that, that's indeed very useful indeed!

Thanks a lot!