Macro / VBA: Automatically Send Emails Via Outlook From Excel

[tommychowdah]

Hi Everyone,

Question for you all.

I have an excel file which has two tabs.

1. Data Tab
2. Report

On the report table I have a drop down to select a clients name, and then the report tab automatically updates with all their information. I have about 1000 clients and need to send them all their own specific email. Is there a macro that can loop through each client from the drop down, create a PDF from the report tab, and email this to the client via outlook? I ahve the emails in the excel file associated with each client.

Best,
Thomas

 

[Logit]

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

For everything email & VBA