Microsoft Office Forums - View Single Post - [Solved] Start MailMerge for 3 different Word documents in Excel depending on value in column A

Kalü · 02-03-2019, 11:50 PM

Hello and thank you very much for your replies!

I think I found out how to change the document paths in Kenneth Hobbson's VBA code:

Code:

Const wdocForm As String = "C:\Program Files (x86)\Microsoft Dynamics\GP2015\Mail Merges\ATT_NE_MM_orig.docx"
  Const xlData As String = \\Sasquatch\Common IS$\GP\Transfer Attendance\Mail Merge Creator.xlsm

is this right? And can you tell me where to put the paths of all three different word documents and how to add the column A loop?

The problem of macropod's answer is that the 3 letters have completely different text and a different amount of sites. All they have in common is the merge fields...