Ask a new question

Repeater Merge Fields to output in the same line instead of listing repeater items in separate rows

Hello,

Can someone help me formatting repeater merge fields output in MS WORD in such a manner that the results will list in the same line using comma separate format?

Currently the multiple outputs are listed in separate rows. for example

PRINCESS

AMIGO

My desired result would be:

PRINCESS, AMIGO

Another issue I am having is when I use the repeater merge fields right after the normal merge field, the output result will repeat the output from the previous merge field again after the repeater merge field ends.

for example

if the merge field <<residentname>> outputs SMITH and the repeater merge field <<PETSNAME>> outputs PRINCESS, AMIGO, my output shows like this:

SMITH PRINCESS

SMITH AMIGO

I want this output to be display in MS WORD as:

SMITH, PRINCESS, AMIGO

sample merge fields

«residentname» «tablestart:pets»«petsname»«tableend:pets»

Thank you

Zack

Answer
Answer

Your reference to fields containing «tablestart:pet» & «tableend:pets» show that you're using a third-party product for your merge, not just Word's mergefields. In that case, you're limited to whatever your third-party product supports. The alternative is to not use the third-party product and rely on Word's mergefields, plus other field coding and/or macros.

You can use Word's Catalogue/Directory Mailmerge facility to group like data (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/showthread.php/154370-Microsoft-Word-Catalogue-Directory-Mailmerge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.
 
For some worked examples, see the attachments to the posts at:
http://www.msofficeforums.com/mail-merge/9180-mail-merge-duplicate-names-but-different-dollar.html#post23345
http://www.msofficeforums.com/mail-merge/11436-access-word-creating-list-multiple-records.html#post30327
http://windowssecrets.com/forums/showthread.php/157725-Word-2010-Merge-from-excel-into-Table-Directory?p=928391&viewfull=1#post928391
 
Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB
 
In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple

Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
With a customized version of the Many to One utility on my MergeTools Add-in to which Paul has given you the link, the data from the child field(s) could be arranged in that way.
Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 8, 2024 Views 1,200 Applies to: