G Guest Aug 17, 2006 #1 I was wondering if it is possible to put a formula in a cell that will send a reminder email on a specified date?
I was wondering if it is possible to put a formula in a cell that will send a reminder email on a specified date?
G Gord Dibben Aug 17, 2006 #2 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
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
