Help With VBA Email

[skate1991]

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