Need a macro code that automatically send email reminder before 30 days of expiry date
Please i need a macro code for the following scenario.Attached a sample excel for your reference.
* My excel sheet contains 16 fields, Expiration Date field tells the expiration of the particular software date. So i need a macro code that will send me a reminder mail before 30 days of expiration date for the particular software. The expiry date should compare with today's date.For a particular software if the expiry is more than 30 days of today's date it should automatically send a reminder mail stating " Your XXXX (Software name) is going to expire in another 30 days"
Please help me !!!
|sample worksheet.xlsx||43.83 KB|