Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
Problem with .send from microsoft example for vba send mail from excel code | Excel Programming | |||
Send email when Condition met? | Excel Programming | |||
A program is trying to send mail using Item.Send | Excel Programming | |||
Send Mail Merge Auto-Emails based on date | Excel Programming |