Hi All,

Greetings and I'am a new member to this forum.

I require to trigger auto emails from the excel macro to a specified email id based on the date field. I require 3 email alerts to be generated based on the date. If the today's date is less than 90 days of the date field, less than 60 days of the date field, less than 30 days of the date field and one more for the overdue (greater than the / equal to the date field). I wish to trigger one email for each condition to specified email ids (in To / CC / BCC) summarising the other data from the row. For eg, if Today's date is less than 90 days of the visa expiry date, the other data in that column to be selected in the email body. Once, all the rows of the sheet are checked, the email is to be triggered.

Please guide me in achieving the same. I use excel 2007 and would like the code to work on other higher versions of excel as well. I have attached the excel sheet with the required fields for your reference.

Thanks & Regards,

SrikaSample by Date.xlsmSample by Date.xlsm