Tech Support Guy banner

VBA Script for sending automatic reminder mails

876 Views 1 Reply 2 Participants Last post by  Keebellah
Hi everyone,
This is my first query on this forum.
I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts.
The details of the input sheet are as shown below:
Col. A 'Sl. no.',
Col. B 'Vendor name',
Col. C 'Effective Date', (mm/dd/yyyy)
Col. D 'expiration Date', (mm/dd/yyyy)
Col. E 'e-mail',
Col. F 'Reminder'

As shown above, a reminder mail should be sent 14 days before the expiry date "Col. D" with the
E-mail message "Your Contract with <Vendor Name> expires on <Expiry date>. Please initiate formalities for renewal of this contract".
This mail would have to be sent to be sent to 15-20 E-mail IDs in Col. E. With the above-mentioned message. Also, once the reminder mail is sent the, the timestamp of that action should appear in Col. F 'Reminder'.
Sample input sheet has been attached.

I'm a beginner at macros and VB, any help would be highly appreciated.

Thank you,


Not open for further replies.
1 - 2 of 2 Posts
Hi Adman,
welcome to the forum.
Have you done a search? There are many similar requests and I am sure there will be one or two that you can used after minor alterations.
Once you have found something we/I can help you further.
1 - 2 of 2 Posts
Not open for further replies.