Email notification

**Kid_k** · 08-30-2011, 07:54 PM

Hi there i have been working on a program that Leith Ross had originally written that emails me when a certain date has passed.
It is working correctly whoever i am wanting to add a cell that gives me the date it was sent so i know an alert has already been made.
I am also trying to have the body of the email add a cell value that the client's name is in so that it will say something like "The repair for [Don O] is due please check spreadsheet"
So for example it takes cell C15 and inserts it into the msg body.

If anyone can help it would be great. I am not sure where ti start to be honest.

**Leith Ross** · 08-30-2011, 08:33 PM

Hello Kid_K,

Here is the update macro. This will insert the person's name from column "C" into the message body.

Please Login or Register  to view this content.

**Kid_k** · 08-30-2011, 11:03 PM

Thank you for this,

It has been a big help.

You rock!

**Leith Ross** · 08-30-2011, 11:05 PM

Hello Kid_K,

Glad to know everything is working well for you. Can this post be marked solved?

**Kid_k** · 08-30-2011, 11:10 PM

Yes just about i am trying to do another test run however i am not getting an emails sent but am receiving no errors. is it because the program is aware of the dates?

**Leith Ross** · 08-31-2011, 02:03 AM

Hello Kid_K,

If there is a date in column "N" then the email will not be sent. After the email is sent, the current date and time is recorded in column "N" for that person. Tot test the emails you will need to clear the cells in column "N".