Email Formula

[Ken McGonagle]

I was wondering if it is possible to put a formula in a cell that will send a
reminder email on a specified date?

 

[Gord Dibben]

Ken

Formulas can only return values.

They cannot perform actions.

Using Conditional Formatting you could change the color of a cell as a reminder
to send the email.

You would need VBA code to actually send an email on a specified date and time.

Ron deBruin has code for sending emails.

http://www.rondebruin.nl/mail/folder3/smallmessage.htm

Chip Pearson has code for OnTime macros.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP