Due Date Reminder With An Email to the filtered list

Closed
Babu546 Posts 7 Registration date Tuesday 20 January 2015 Status Member Last seen 26 January 2015 - 26 Jan 2015 à 07:59
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 27 Jan 2015 à 16:41
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 31 August 2010 Status Contributor Last seen 20 June 2016 26
27 Jan 2015 à 16:41
Ron De Bruin has an extensive list of routines to enable emailing from Excel.

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