Automatic Outlook mail due date reminder based on Excel file

billrigsby

New member
Joined
Jan 17, 2018
Messages
1
Reaction score
0
Points
0
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 have attached a snip of our very large SS,


when the date in M6 is a week out I want an email sent to xxxxx@xxx.xxx 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
 

Attachments

  • 2018 Permit Tracking Spreadsheet snip.xlsx
    20.1 KB · Views: 108
Back
Top