Email alerts
 

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?

Email alerts
 

Hi Frank

Is the date manual entered

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
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?

Email alerts
 

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

"Ron de Bruin" wrote:

Hi Frank

Is the date manual entered

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
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?

Email alerts
 

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
Yes the date is manual entered from anywhere to a month to a year out.

"Ron de Bruin" wrote:

Hi Frank

Is the date manual entered

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
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?

Email alerts
 

Thanks Ron, this was a big help.

"Ron de Bruin" wrote:

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
Yes the date is manual entered from anywhere to a month to a year out.

"Ron de Bruin" wrote:

Hi Frank

Is the date manual entered

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
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?