MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Generate and send an email based upon a formula result?!?!?


Posted by Dustin on March 29, 2001 1:43 PM

How would I create and send an email based upon the results of a formula...

Example:
I would like to create a spreadsheet that has the columns:
-----A-------B----------C-----------D------------E-----
1-----------Time-----Address-----Subject-----Message---
2-(Formula)-18:00---tomthumb@..--hello-----Good Day,..
3-(Formula)-20:00---joesmith@..--You Won!--Congrats...

Basically I would like to have the formula determine if the current time equals the time in the B column and if so, generate and send an email with the appropriate address, subject, and message content.

Is it possible, and if so how?

Thanks very much,
Dustin


Posted by Dax on March 30, 2001 2:10 PM

I know how to do this if you're using MS Outlook. It's quite involved so I'll post it if you reply saying Yes, you do use Outlook.

Regards,
Daxum.

Posted by Dustin on April 03, 2001 2:59 PM

Yes, I do use Outlook. Thanks Dax.