Due Date Reminder With An Email to the filtered list

Closed
Babu546 Posts 7 Registration date Tuesday January 20, 2015 Status Member Last seen January 26, 2015 - Jan 26, 2015 at 07:59 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Jan 27, 2015 at 04:41 PM
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 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jan 27, 2015 at 04:41 PM
Ron De Bruin has an extensive list of routines to enable emailing from Excel.

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