Reminder Email from Excel on specified dates in a cell.........

Hello,

I have recently joined the forum and i have query on Excel reminder.
can you provide or advise whether an excel can send a reminder email on a specific dates mentioned in a cell? i have a list of users with their subscriptions with the other details, also i have a date mentioned as renewal date or due date of their subscriptions.

I want to know can i get a reminder on that dues dates and also can i send an automated email for the same.

Also for your information i dont know VBA/Macros.

It would be highly appreciated if you could write or provide some codes for the same. I have attached a sample data for you to work on.

Thanks once again!!!

Hi Sachin,

I have added the code into your sample workbook which you should be able to adapt to your needs.

I have assumed you use MS Outlook as your email client. At present you would have to open the workbook each time and run the macro to get the emails to send.

Let me know if this is what you were aiming for and if you have any questions or alterations I will try to accommodate if I have time.

Stuart