Automatic Outlook mail due date reminder based on Excel file - REVISITED

Here 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=1515512564