send automatic email on multible dates until checked off completed.

Please help if you can, I know very little about excel and I have a very complicated spreadsheet to build.

If I can pull this off, it will help me fight the coming layoffs.


Problem

I need excel to send automatic email when the spread sheet is opened to the supervisor every time a check in date hits and to keep emailing them everyday until they mark the cell next to the date as completed. I need to learn VB for this and I am running out of time!

Same thing for the shift manager complex manager and HR.


Am working on the small stuff but am struggling with the emails.

I really need some help and fast, I can repay the favor with translations, building basic spreadsheet or let me know what I can do to pay you back for helping. I really help please. I will give you my cell number in PM if needed.


If possible, I need to have this done by 3pm Monday 01/08/2016.

Forgot Sheet!