Hello,

I am working on a template and need to know how to add multiple merge fields to a sentence without causing a bunch of extra commas and periods if only 1 of the fields gets filled.



We are sending letters as reminders to pay bills, and each person will have between 1 and 4 bills that need to be listed.

If I add all 4 of the merge fields to the sentence in the template, the spacing, commas, and "and" get left at the end of the sentence (if they have fewer than 4 bills)

How can I make a rule to prevent this conjunction and punctuation pileup?

Thank you

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