View Single Post
 
Old 07-18-2023, 05:59 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This is called concatenation and requires nested fields using If fields. See Making your mail merge “intelligent” by using IF fields for an example.

Depending on where you are getting your source data for the merge (eg Microsoft Access), it may be simpler to build a SQL query there which uses the CONCAT function to do the tricky stuff so that the Word Mail Merge simply grabs that result. Threads like the following might give you clues (or keywords you can search further on).
Concatenate fields and insert comma between: how to handle nulls – SQLServerCentral Forums
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote