Macro needed for tracking chart

Hello!
Please see attached spreadsheet… I need assistance creating a macro that does the following 4 things:

1. Send auto email to: [email protected] MONTHLY starting 6 months before EXPIRATION DATE (Column E). The body of the email, can just say REMINDER FOR (Same Row, Column A) that Certification Training (Same Row, Column B) is Due to Expire on (Same Row, Column C). Please renew or contact your supervisor as soon as possible.

2. Once an e-mail is sent, I also need Column F (which is blank right now) to READ: “1 REMINDER SENT” at 6 months, “2 REMINDER SENT” at 5 months, “3 REMINDER SENT” at 4 months and so on… *Basically this column is to know how many auto e-mails were sent.


3. Color Code the Cell in Column F. Fill the color of the cell in column F, depending on the following:
- Reminders sent at 6 month & 5 month = Green Filled Cell
- Reminders sent at 4 month & 3 month = Yellow Filled Cell
- Reminders sent at 2 month & 1 month = Red Filled Cell

4. For those who DO NOT COMPLETE their certification, I need ONE auto e-mail sent saying:

“No information for (Same Row, Column A) – Training Titled (Same Row, Column B) has been received. Due Date Has Expired.”

Excel will know to send this e-mail because Column C “Due Date”, will be todays Date and Column E in that same row will be blank.


I need this macro as soon as possible. If anyone can help, it would mean tons for me!!! THANKS SO MUCH, I Look forward to hearing your responses.

OK, I have some of the code written, please see below....
If someone, anyone can help me get this going, the code isnt showing any errors, but its also not working?

Any information would help right now. THANKS!

Please Login or Register  to view this content.

Hi ExcelGuroo

Please wrap any Code you post in Code Tags, it's a Forum Requirement. To do so, edit your Post, highlight the Code, Click the # (pound sign) icon, Save the changes.

In the meantime, what's the relevance of this Line of Code? Your Data starts on Line 4 and extends to only Column F.

Please Login or Register  to view this content.

Hi ExcelGuroo

I don't care where your Data ends...the Code will find the Last Row with Data.

In the Real World where will your Data Start. In your Sample File it starts on Row 4 (the Header Row).

In the Real World how many Columns will your Data have. In your sample File it has 6.

If your REAL File is not of the SAME STRUCTURE as your Sample File then we're wasting my time...and I don't have time to waste.

Hi ExcelGuroo

You'll need to play with the Code in the attached letting me know what it's doing properly and what it's not doing properly as I see no examples of this in your Sample File...accordingly, I don't know what this means or how to Code for it.

Excel will know to send this e-mail because Column C “Due Date”, will be todays Date and Column E in that same row will be blank.

Please Login or Register  to view this content.