How to insert a field in a mail merge that returns multiple rows of a same "person" in a worksheet?

Example source worksheet:

Name: City:
A New York
A Miami
B New Orleans
C London
C Paris

In this example the mail merge will result in 3 pages (A, B, C), the merge field "Cities" should return 2 lines (New York and Miami) for A page, 1 line for B (New) Orleans, 2 lines for C (London, Paris), and so on.

This tutorial will work in this case?
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

I was using this concatenate sub:


https://www.mrexcel.com/forum/excel-...nate-data.html

But I want to know if there's a way to do that within word mail merge.


Thanks.

__________________
Backup your original file before doing any modification.

The short answer to your question is no. If Paul's tutorial isn't suitable then see http://www.gmayor.com/ManyToOne.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Did you try it? The same tutorial is even available on this site: https://www.msofficeforums.com/mail-...-tutorial.html
For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327

Another possibility, depending on your data & needs, is to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
Conversely, if you're using a relational database or, Excel workbook with a separate table with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at:
https://answers.microsoft.com/en-us/...f-8642e46fa103
For a working example, see:
https://www.msofficeforums.com/mail-...-multiple.html

The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: https://www.msofficeforums.com/mail-...html#post67097

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks gmayor and macropod.
I didn't try cause I was thinking that it's only suitable for summation.

I'll take a look at those links and suggestions.

__________________
Backup your original file before doing any modification.