<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Accept: Koen (<a href="https:#a42501724" rel="ugc">https:#a42501724</a>)<br />
<br />
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.<br />
<br />
seth2740<br />
Experts-Exchange Cleanup Volunteer
</div>


<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Dynamic Subject Line for Mail Merge- Excel / Outlook 2016

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.