Email to one email address when a due date is close

[guido0136]

Hello all: This is my first post as so far I have always been able to find what I need, but this time I have not been able to find something that works for me.

I have attached a test file that I have been working with. Basically it's a temporary employee tracking sheet. What I would like the sheet to do is to email out a notification to one set email address when a temporary employee is 2 weeks from their planned end date (If known). I am not sure how to do this. I would like for it to run in the background but I realize that is not possible when the file is not open. So I wish for this Macro/VBA to run every time the file is opened.

Thanks in advance

G.