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.