Help With VBA Email

HI,

I’m wouldn’t even call myself a novice at VBA, but I think the below will be able to be done.

I have a spread sheet (Attached)

Cell A (Start Date)
Cell B (Today Date Formula)
Cell C (Amount of Working Days Between the Two Dates Using Networkingdays Formula)
Cell D (Job Number Will need to be sent in the email)
Cell E (Client Will Need To Be Sent In The Email)
Cell F ( Coordinators Name)
Cell G (Coordinators Email, Which The VBA Should Send It To)

What would be ideal is that when column C goes down to two working days it to send an email to the coordinator email address in col, saying something roughly like Job number “50245875” for “Client 1” you need to responded to the client as it is going over due.

Do you think this is possible or something similar.

Thanks

Thanks Richard for the above,

I'm not sure what you mean by what event you would want to trigger this ??

Thanks

Does anyone have any Ideas????

HI,

I managed to figure out the event trigger,

But when I put in multiple rows it comes up with a bug please see the attached image,

debug.docx


I have also attached the document I'm working on.

Thansk