Hi DerikK

You can use a macro like this
http://www.rondebruin.nl/mail/folder3/message.htm

And run it every day or use Ontime to do it
http://www.cpearson.com/excel/ontime.htm

But you have a problem with the Outlook security warning
You can use this example maybe (read the whole CDO page)
http://www.rondebruin.nl/cdo.htm#message



--
Regards Ron de Bruin
http://www.rondebruin.nl


"DerikK" wrote in message
...

I test commercial fire alarm systems and use Excel to keep track of my
clients / contracts. The tests are performed anually and I need
notification 45 days in advance of the 1 year anniversary of the
previous test. Is there any way to set up Excel to monitor my "Test
Date" column and send me email notification automatically? Or does my
question make absolutely no sense whatsoever?


--
DerikK
------------------------------------------------------------------------
DerikK's Profile: http://www.excelforum.com/member.php...o&userid=25121
View this thread: http://www.excelforum.com/showthread...hreadid=386239