I have a conditional format linked to a calender that will change the cell
colour when the date of the cell becomes todays date (becomes due).

I would like to know if it is possible to get ecxel to send an email when
the cell date is current with todays date as well so it will let me know
without opening the file.

Any help would be great.

Thanks

Excel can send an email, but you need to program it in Visual Basic, and
excel won't do anything unless you open the file first.

"will07" wrote:

I have a conditional format linked to a calender that will change the cell
colour when the date of the cell becomes todays date (becomes due).

I would like to know if it is possible to get ecxel to send an email when
the cell date is current with todays date as well so it will let me know
without opening the file.

Any help would be great.

Thanks

Thanks for the answer. I thought that might be the case.

Regards

"dlw" wrote:

Excel can send an email, but you need to program it in Visual Basic, and
excel won't do anything unless you open the file first.

"will07" wrote:

I have a conditional format linked to a calender that will change the cell
colour when the date of the cell becomes todays date (becomes due).

I would like to know if it is possible to get ecxel to send an email when
the cell date is current with todays date as well so it will let me know
without opening the file.

Any help would be great.

Thanks