send automatic email

Dear all,

as per attached i have a list of id cards which will expire soon, so is it possible to receive an automatic eamil notifying me into my outlook email address ?

please see my xls for all details

thank you for usual help

Hi..

Add this to your WorkBook_Open Event.. every time you open the Workbook.. it will check to see if any are Overdue..

Also.. I added a Column that shows if an email has already been sent.. and if so.. an email will not be sent again to that person..

You could change that so the limiting factor is a certain number of emails (Reminders) sent instead of just "Yes".

Please Login or Register  to view this content.