Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-03-2018, 03:34 AM
eduzs eduzs is offline Mail merge multiple rows Windows 10 Mail merge multiple rows Office 2010 32bit
Expert
Mail merge multiple rows
 
Join Date: May 2017
Posts: 266
eduzs is on a distinguished road
Default Mail merge multiple rows

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge multiple rows How do I mail merge multiple rows into one letter? SusiLouhh Mail Merge 1 03-17-2017 09:03 PM
Mail merge multiple rows Mail Merge Multiple Rows format issue Peterlar Mail Merge 4 07-14-2016 04:50 AM
Mail merge multiple rows mail merge multiple rows within a grouping 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
Mail merge multiple rows Mail Merge multiple rows? ender541 Mail Merge 1 08-21-2012 03:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft