Automatic Outlook mail due date reminder based on Excel file

[billrigsby]

[h=2][/h]

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,

I cannot attach (?) 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
​

 

[ranman256]

well the xl file would have to open,
then what? does is scan a list of dates on 1 sheet? Are the DueDates on separate sheets?

 

[billrigsby]

well the xl file would have to open,
then what? does is scan a list of dates on 1 sheet? Are the DueDates on separate sheets?

I was wondering if the file would need to be opened or not?
All dates are in column M (M6, M7, M8,etc,)


Bill