How to automatically get excel to send an email 30 days prior to an expiry date

[CPitchers]

Hi all, i have i training/skills matrix which record employee names and qualifications held along with expiry/renewal dates for the qualifications.

I want for the sheet to automatically send an email to the training manager 30 days prior to expiry

any help would be apreciated

 

[daverunt]

Hi similar work done here.

Send Email via Outlook based on Excel due Date

Hi Guys, I need expert to guide and show me how to send email automatically (via outlook) if the due date is near and already expire. The data available in row by row. I've 2 emails address in my column D and E respectively. If near due date (2 days before due), will send email to address # 1...

www.mrexcel.com

Send email based on date

Hello All, I am hoping someone can help me here. I am using the code below to send an email in outlook from excel. The general idea is that the sheet would have people's names in columns A&B, email address in column C, and the date that their training is due in column D. What I would like to...

www.mrexcel.com

I would create a daily schedule in Task Scheduler to open the macro workbook.
Inside the macro workbook I would have a Workbook_Open event to call the required macro.