Auto Emails through VBA on Specific Date

Hi Guys,

I have searched the forum and I couldn't find any specific/close topics.
http://www.excelforum.com/excel-prog...-in-excel.html
http://www.excelforum.com/excel-prog...ing-dates.html
http://www.excelforum.com/excel-prog...rom-excel.html
http://www.excelforum.com/excel-prog...tain-date.html


Basically, I have a file which has column of deadlines. I need Excel to auto send emails to me with the data corresponding to that deadline.
I have attached sample data. The Red Column are the deadlines, the data in the corresponding yellow cells are what I need emailing to me.

Date of email to be sent: 7 days before deadline [column A]
Time for emails to be sent: 09:30am
To: [email protected] (testing purposes)
Email Subject: "Product Deadline Approaching: [Date of deadline]"
Body of email:

"The below products are expiring

Deadline: [DATE - Cell A4]
Cycle:[DATE - Cell B4]

Product Deadlines
All Products
T&C: [DATE - Cell C4]
Ideal: [DATE - Cell D4]
Late with agreement: [DATE - Cell E4]

Primary Products
All Products
Product A: [DATE - Cell G4]

Primary Products
Other Products
Product B: [DATE - Cell H4]
Product C: [DATE - Cell I4]
Product D: [DATE - Cell J4]

Manufacturing Date
Product A: [DATE - Cell L4]
Product B [DATE - Cell M4]
Product C [DATE - Cell N4]

Thanks"

let me know if you need more info

Thank you for your help :)


Tai