Due Date Reminder With An Email to the filtered list

[Closed]
Report
Posts
7
Registration date
Tuesday January 20, 2015
Status
Member
Last seen
January 26, 2015
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,

Here I have a filtered list from Master Sheet to DueReminder Sheet

In which column I represents Email address

Now my motive is to send an alert mail to those Email Address who gets filtered With a Template mail

There is a Command Button " Send Mail " there in Column J

I want to send the mail when the command Button clicked By me.

I want to do this with Outlook mail i have a Outlook Mail id with that mail id only i want to send that template mail to filtered list in DueReminder Sheet

Please Help Me in this Regards

I am Sharing My File with you for Better Understanding

http://speedy.sh/NUgCB/babu-Due-Date-Reminder.xls

any assistance will be greatly appreciated

Thanks in advance




1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Ron De Bruin has an extensive list of routines to enable emailing from Excel.

https://www.rondebruin.nl/win/s1/outlook/mail.htm