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