Hello,
I'm trying to combine the following two pieces of code, both of which were found online, into a macro that will:
1. Loop through a distribution list
2. Create a new email for each listed email address
3. Attach a PDF to each email based on the name in the "to field"
4. Save...
Hello,
I cobbled together the following code (which is designed to loop through a template folder, open each file, and save it as a draft) from examples online. It's presented below.
Public Sub CreateFromTemplateLoop()
Dim MyItem As Outlook.MailItem
Dim myOlApp As Outlook.Application...
Hello,
I have an Outlook distribution list of ~50 clients, each of whom needs to be emailed a personal Excel report once a week. I want to produce a macro that would loop through the distribution list, pull the individual email addresses, and apply each address to its own template. The...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.