Send e-mail based on condition

[Lauren C]

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 ***

 

[Ron de Bruin]

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