Send e-mail based on condition
I'm sure there are a lot of threads on this subject and I have looked at A LOT of them, however, I am not familiar enough with VBA to modify the codes specifically to what I want. After reading an e-mail, if there is a post that addresses specifically what I need, then please direct me there. Otherwise, I'd appreciate some help. I have formatted the cells in column H, which contain an expiration date, to turn red when it is either 7 days away from the date or on/past the date. In addition to this, I would like to send an e-mail based on the addresses in column C (with the recipient name from column B) when the condition in column H is met (i.e. when it is 7 days away). I would like this e-mail to send automatically. I've fiddled with Ron de Bruin's codes but cannot seem to get it to work with my specifics and not the "yes/no" condition he has. If someone can help me out, I'd greatly appreciate it. Thanks! *** Sent via Developersdex http://www.developersdex.com *** |
Send e-mail based on condition
I think I will choose this macro and open the workbook ones a day and run the code
http://www.rondebruin.nl/mail/folder3/message.htm You can also use Ontime to run the code http://www.cpearson.com/excel/OnTime.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lauren C" wrote in message ... I'm sure there are a lot of threads on this subject and I have looked at A LOT of them, however, I am not familiar enough with VBA to modify the codes specifically to what I want. After reading an e-mail, if there is a post that addresses specifically what I need, then please direct me there. Otherwise, I'd appreciate some help. I have formatted the cells in column H, which contain an expiration date, to turn red when it is either 7 days away from the date or on/past the date. In addition to this, I would like to send an e-mail based on the addresses in column C (with the recipient name from column B) when the condition in column H is met (i.e. when it is 7 days away). I would like this e-mail to send automatically. I've fiddled with Ron de Bruin's codes but cannot seem to get it to work with my specifics and not the "yes/no" condition he has. If someone can help me out, I'd greatly appreciate it. Thanks! *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 02:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com