Email notification

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.