Start MailMerge for 3 different Word documents in Excel depending on value in column A

Kalü · #1 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...

macropod · #2 02-04-2019, 04:43 AM

Quote:

Originally Posted by Kalü

The problem of macropod's answer is that the 3 letters have completely different text and a different amount of sites

Those issues are quite irrelevant. All you need to manage that is three IF fields for the whole document - one for each letter.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailmerge Excel with a Master Word Template (via VBA)	stevenel	Excel Programming	8	08-14-2018 03:05 PM
Rounding Up or Down depending on Start & End time	richardst	Excel	4	06-21-2016 06:03 PM
Marking specific cells depending on start and end time entered	ellebb85	Excel Programming	0	01-17-2016 02:50 AM
documents saved with double column revert to single column when re-opened	danw	Word	6	04-08-2015 06:24 AM
Merge Word documents using a mailmerge field	Concertina	Mail Merge	3	02-18-2013 04:12 AM