Email alerts

[Guest]

I am not sure if Excell has the capability to email alerts to individuals
when a task is due.

for example,

If I build a tracking spreadsheet for personel actions and there is a due
date in the spreadsheet, is there a way to receive an email when the due date
hits?

 

[Ron de Bruin]

Hi Frank

Is the date manual entered

 

[Guest]

Yes the date is manual entered from anywhere to a month to a year out.

 

[Ron de Bruin]

Hi Frank

You can run a macro like this (see example 2)
http://www.rondebruin.nl/mail/folder3/message.htm

You can look at this page to run the macro every day
http://www.cpearson.com/excel/ontime.htm

 

[Guest]

Thanks Ron, this was a big help.

Hi Frank

You can run a macro like this (see example 2)
http://www.rondebruin.nl/mail/folder3/message.htm

You can look at this page to run the macro every day
http://www.cpearson.com/excel/ontime.htm