excel spreadsheet with e-mail notification when due date arrives
 

Hi Karen

Please put your question in the body and not in the header next time

Start here
http://www.rondebruin.nl/mail/change.htm

You can create a formula cell that change to yes when the due date arrives.
Check for yes then in the change event

Give more information if this is not what you need


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


"karen gomez" <karen wrote in message ...

Another way is to check the date in the workbook open event and to run the mail sub from there.

See Chip Pearson's site for more info
http://www.cpearson.com/excel/events.htm


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


"Ron de Bruin" wrote in message ...
Hi Karen

Please put your question in the body and not in the header next time

Start here
http://www.rondebruin.nl/mail/change.htm

You can create a formula cell that change to yes when the due date arrives.
Check for yes then in the change event

Give more information if this is not what you need


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


"karen gomez" <karen wrote in message ...