excel spreadsheet with e-mail notification when due date arrives

[Ron de Bruin]

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

 

[Ron de Bruin]

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