I have an excel macro that creates an email in outlook using a template. Col A is the email address; Col B is the subject. The macro works, except when it loops through the list, instead of creating a new email and saving it as a draft, it overwrites the email.
Sub test_send()
Dim...
I found the macro that takes fields from excel and sends an email.
I would like to create an email from an outlook template, populate fields from excel and save it as a draft.
Here's the outlook/VBA macro - I'd like to pull from excel the following columns:
Email Address, Meeting Date, First...
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.