send e-mail alerts by due date

[Jim Hunter]

In excell 2003, I enter data, including, contact, action required, and due
date.
Am I able to have each contact sent e-mail alerts on due date.
You might suggest another program for this.

 

[FSt1]

hi
no. you can do it with outlook and excel.
see this site for details.
http://www.rondebruin.nl/sendmail.htm
scroll down. under "other tips" look for "send mail when cell reaches a
certain value" ie when due date = today (or) send mail.
there are several examples. requires code. so if your not up on using code
then see this site also.
http://msdn.microsoft.com/office/un...ibrary/en-us/odc_xl2003_ta/html/odc_super.asp
http://www.mvps.org/dmcritchie/excel/getstarted.htm

good luck
FSt1