#1
|
|||
|
|||
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!! Last edited by slc345; 10-28-2019 at 03:27 PM. |
#2
|
||||
|
||||
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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Quote:
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!!! |
#4
|
||||
|
||||
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 |
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 with Mulitple Rows | KDP | Mail Merge | 7 | 11-27-2017 10:00 PM |
How do I mail merge multiple rows into one letter? | SusiLouhh | Mail Merge | 1 | 03-17-2017 09:03 PM |
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 |