![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
SusiLouhh | Mail Merge | 1 | 03-17-2017 09:03 PM |
![]() |
Peterlar | Mail Merge | 4 | 07-14-2016 04:50 AM |
![]() |
tracygleghorn | Mail Merge | 12 | 11-12-2015 06:43 AM |
Mail Merge Multiple Rows Into One Document Grouped | ryano | Mail Merge | 4 | 03-23-2015 04:27 PM |
![]() |
ender541 | Mail Merge | 1 | 08-21-2012 03:14 PM |