Emailing based on expired dates weekly

[scottyb1977]

Hi everyone I am fairly new to VBA and excel but here is what I am trying to do. I want my excel file to check the dates in column "b" a week in advance and send an email if the date is expired. This program will be opened once a week so I want it to check up to 7 days in advance and send the email out for the expired serial numbers. Then if a week later if the serial is still expired then send another email and continue each week if the conditions still apply. Please Help! Thanks in Advance!
Here is an example of what I want. The program will have more than 5 serial numbers. it will probably be around 200 or so. Again thanks!

 

[Trevor G]

The image has been uploaded. You need to place the picture into a web area, like dropbox if you can't use the screen capturing options from Mr Excel.

 

[scottyb1977]

I am not sure what you mean but here is what the screen shot looked like.

A B C
Serial Date Check
1 101 5-5-16 Good
2 220 4-5-16 Good
3 223 3-30-16 Expired
4 332 3-28-16 Expired
5 443 3-24-16 Expired

The Column C has a formula in it that uses today's date compared to Column B.
I want the rows that are expired to be emailed. I want the email to say the subject "Expired", the body to list the serial # the date of the expired serial #'s and on the last line to say "Please Check Calibrate Dates". This program will be opened once a week and if the calibrations is the same I want it to include it again until the calibration date has been changed.
Thanks in Advance and if you need anything else please let me know.

 

[scottyb1977]

C:\Users\sboudreaux\Documents\EJHTMLe\TempJean.htm