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

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

I forgot : In the Yes/No column use a formula that will display Yes if it is 45 days in advance.

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


"Ron de Bruin" wrote in message ...
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

Ron

Thanks for the info, but I think I'm a little out of my league here.
I've never worked with macros or anything like that.

Basically, Column F in my sheet is full of dates( 14-Nov-04 ). I'm
trying to set things up so that it would automatically email me on
06-Oct-05 with the customer info so that I can set up the next test.
Will the info you supplied do this and if so can I just copy and paste
(obviously changing the notification text)?

If it's not possible to do this, is there a program that you know of
that might be able to do this?

Thanks for your time,

Derik


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

Hi Derek

Check it out with your IT department
Maybe they block it or your firewall is doing it

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


"DerikK" wrote in message
...

Ron

Thanks for the info, but I think I'm a little out of my league here.
I've never worked with macros or anything like that.

Basically, Column F in my sheet is full of dates( 14-Nov-04 ). I'm
trying to set things up so that it would automatically email me on
06-Oct-05 with the customer info so that I can set up the next test.
Will the info you supplied do this and if so can I just copy and paste
(obviously changing the notification text)?

If it's not possible to do this, is there a program that you know of
that might be able to do this?

Thanks for your time,

Derik


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