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 ...