Microsoft Office Forums Mail Merge Letter with mulitple rows of data for each recipient

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2019, 12:19 PM
slc345 slc345 is offline Mail Merge Letter with mulitple rows of data for each recipient Windows 10 Mail Merge Letter with mulitple rows of data for each recipient Office 2019
Novice
Mail Merge Letter with mulitple rows of data for each recipient
 
Join Date: Oct 2019
Posts: 2
slc345 is on a distinguished road
Default Mail Merge Letter with mulitple rows of data for each recipient

Hi all,




Can you please assist with helping me set up my letter. I previously used the "formulas" with success but am now receiving an error message. Attached is the letter I'm trying to put together along with the spreadsheet.


I've also tried using Mail Merge4 document and the data from the spreadsheet is going on separate pages instead of in the single document.


I guess I've lost some brain cells since I last did this . I've tried reading the tutorial over and over but am totally lost and could really use your help and guidance.


Thank you so much!!







Attached Files
File Type: docx 2019 Product Discontinuaton Customer Notification .docx (17.7 KB, 4 views)
File Type: xlsx AJ Customers.xlsx (13.8 KB, 2 views)
File Type: docx Mail Merge-4Final.docx (16.9 KB, 4 views)

Last edited by slc345; 10-28-2019 at 03:27 PM.
Reply With Quote
  #2  
Old 10-28-2019, 10:11 PM
gmayor's Avatar
gmayor gmayor is offline Mail Merge Letter with mulitple rows of data for each recipient Windows 10 Mail Merge Letter with mulitple rows of data for each recipient Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,029
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

May I suggest that you employ Merge Many To One which, with some minor changes to your letter (attached), will produce the results required - example also attached.
Attached Files
File Type: zip Examples.zip (34.4 KB, 12 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 10-29-2019, 11:05 AM
slc345 slc345 is offline Mail Merge Letter with mulitple rows of data for each recipient Windows 10 Mail Merge Letter with mulitple rows of data for each recipient Office 2019
Novice
Mail Merge Letter with mulitple rows of data for each recipient
 
Join Date: Oct 2019
Posts: 2
slc345 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
May I suggest that you employ Merge Many To One which, with some minor changes to your letter (attached), will produce the results required - example also attached.


Thank you "Master" Graham!!!


I can't believe how easy you made this ...embarrassing.


As a follow up, is there a way to create individual letters from a directory as you can do with the letter templates?


Thanks again!!!
Reply With Quote
  #4  
Old 10-31-2019, 06:14 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge Letter with mulitple rows of data for each recipient Windows 10 Mail Merge Letter with mulitple rows of data for each recipient Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,029
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Quote:
Originally Posted by slc345 View Post
I can't believe how easy you made this
......
As a follow up, is there a way to create individual letters from a directory as you can do with the letter templates?
It was a lot of work and many revisions, as for the rest, something got lost in translation here - what exactly are you trying to do? If you mean split letters using a directory merge, then see Paul's tutorial at the top of this forum.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with multiple rows of data empresslee Mail Merge 7 04-04-2019 03:07 PM
Mail Merge Letter with mulitple rows of data for each recipient Mail Merge with Mulitple Rows KDP Mail Merge 7 11-27-2017 10:00 PM
Mail Merge Letter with mulitple rows of data for each recipient How do I mail merge multiple rows into one letter? SusiLouhh Mail Merge 1 03-17-2017 09:03 PM
Mail Merge Letter with mulitple rows of data for each recipient Merging Multiple Rows in Mail Merge Letter hrhr3 Mail Merge 4 08-24-2016 07:37 PM
Mail Merge a letter to headmasters with rows of data/students assoc. w/school sgaeta Mail Merge 7 04-10-2014 06:34 AM


All times are GMT -7. The time now is 05:48 PM.


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