Send Automatic Email from Closed Excel Workbook

[Joshy_1303]

Hi Guys

I have an Excel workbook for Contractor Vehicles which has the date's of site vehicle inspections. Every 3 months we ask for an updated vehicle inspection.

I have an EDATE formula to calculate when an inspection last occurred (column I - manual input); when an inspection will expire (column J - =IF(ISBLANK(I2),"",EDATE(I2,3))); and when we (the employer/company) will begin to prompt the contractor to make sure their next 3 month inspection will be completed (column k - =IF(ISBLANK(I2),"",EDATE(I2,2))). Column K is set up to allow for a months' notice.

I would like to set up an automated email notification for when the date in column K has been reached, even if the workbook is closed.

1. Can this be done from a closed workbook?
2. If not, can I set up an auto-open of the Excel workbook (via Task Manager - also new to me) at the end of every month and set up an automated email based on the date in column K?

Thanks in advance for any help.