Automatic Outlook mail due date reminder based on Excel file

Hello I am in need of something way over my head...............


I am in need of a script to automatically send out an email when a date is a week out,

Attached is a snip of our very large SS, when the date in M6 is a week out I want an email sent stating

(A6) Permit Number (C6) Utility "As Builts Are Due" (M6) Date or

18001 ABC As Builts Are Due 03/02/18


The script should preferably run automatically every time the PC is running. without the excel file necessarily open.



Thanks Bill


https://www.excelforum.com/attachmen...1&d=1516210972