VBA Script for sending automatic reminder mails

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Adman8

Thread Starter
Joined
Jul 14, 2017
Messages
2
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,
Adman
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top