excel sending an email when a date is crossed

[thetzler]

I have a spreadsheet with dates in one colume. I have a macro that will email the spreadsheet to myself but I want it to send when those dates are hit. just that day would work but I would also like to specify the hour if possible. Any ideas.
I'm also trying to find a way to get a spreadsheet to open up either every morning or once a week so that the macro's will run and send the spreadsheet without me having to open it up.

I hope that makes sense.

 

[Ruddles]

To run an application at a scheduled date and time, use the Windows Task Scheduler.

It sounds as though you need some code in the Workbook_Open event to check the dates in your sheet and generate an email when one of them is due. (You might need to set a flag against the date to indicate that it's been taken care of, to prevent it from being processed again.)

My advice would be to develop the whole thing in stages, getting one bit of it working at a time. If you try to implement the task scheduling, the triggering of Workbook_Open, the code to loop through the worksheet, the checking for expired dates and the generating of the emails all at the same time, if it doesn't work you might be struggling to work out which bit is at fault.

 

[thetzler]

Maybe I am to elementery at this but what is windows task scheduler?

 

[Ruddles]

I could spend ages typing a comprehensive description but I could never do it as well as Microsoft.

So I won't even try!

http://msdn.microsoft.com/en-us/library/aa383614(VS.85).aspx

 

[daverunt]

There's a bit on workbook_open and email with dates in this link, which may get you started.
http://www.mrexcel.com/forum/showthread.php?t=512138