Hi

I am maintaining data of employees in excel. They all have a licence (with an expiry date). excel contains details like name, email, license expiry date, etc.

2 questions

1. Is it possible that an email is sent automatically to the employee (whose license is going to expire in exactly 30 days from now)? with or without opening excel file containing data?

2. email sent to a single email id that license of "abc" employee to expire on dd/mm/yyyy? with or without opening excel?

PS: I believe we can set the macro to run as soon as excel file is opened.

Thank you