Hi,
I have quite a large spreadsheet that references a number of dates in column J. I want to have the spreadsheet automatically send an email based on when these dates come within 10 days of the actual date. I do not know if this can be done through "Windows Task Scheduler" and "WorkBook_Open" to run the macro.
I also want the email to reference text in the corresponding cell (column F) of the same row.
Any help on this would be greatly appreciated.
Bookmarks