Dynamic Subject Line for Mail Merge- Excel / Outlook 2016

mat near
mat near used Ask the Experts™
on
Hi, I am using outlook 2016 with MS Excel 2016 I am using mail merge to create bulk emails. I can create the main body of text fine with the correct fields I need. The problem I have is when I come to send the emails I cannot make the subject line dynamic as I want to use one of the subject fields from excel for each email plus a little bit of standard text. Would I need to run a macro to do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SDM Mobile
Commented:
yes, there is no standard way to make the subject line in an mail merge.

the only way to do it is to create your mail by code (macro), and loop through your records. if you need help with this shout.
Seth SimmonsSr. Systems Administrator

Commented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Koen (https:#a42501724)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

seth2740
Experts-Exchange Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial