Auto Send Emails Based on Due Date

**Nuclearman83** · 03-23-2012, 12:34 PM

I am new to VBA but I have a spreadsheet that calculates when everyones qualifications are due. "A2" is there name, "D2" is due date and "G2" is their email address. I need to auto send an email when they are one month from their due date stating that it is coming due. If it could also copy that row with their info it would be even better. I have dug all over the internet but every time I copy and paste a code it always comes up with errors. Thank you for your help.

**mrmarchuk** · 03-23-2012, 12:38 PM

you're going to get asked anyways so can you attach a copy of the spreadsheet you're working with? sample data is suggested

also, you would want to post this in Excel Programming, not Excel General

**Nuclearman83** · 03-23-2012, 12:46 PM

Sample.jpg

Thank you for the information and next time I will. Sorry still new to this forum. This is not my actual spreadsheet but an example so that I can see how the code is written. Thank you.

**royUK** · 03-23-2012, 12:55 PM

It's a picture, we need a workbook with data. beter still search the forum you will find dozens of similar questions with answers.

**mrmarchuk** · 03-23-2012, 01:08 PM

Originally Posted by royUK

It's a picture, we need a workbook with data. beter still search the forum you will find dozens of similar questions with answers.

nuclear, check if this has answers, it's something i was working on

http://www.excelforum.com/excel-prog...pirations.html

**Nuclearman83** · 03-23-2012, 02:54 PM

Thank you both for the help i think that I just need to really study up on my VBA. Its just hard for me to decipher all the code and change it to what I need.