View Single Post
 
Old 09-07-2018, 08:38 AM
ARoude ARoude is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Sep 2018
Posts: 2
ARoude is on a distinguished road
Angry Mail merge with multiple rows of data

Hello everyone, I'm hoping someone here can help me before I rip my hair out.

I have a couple of legal document templates I currently work with, but I need to make them merge from an excel sheet with all my data. Sounds easy enough, except each owner on my sheet has multiple rows worth of data within multiple columns. Each owner would need to be on their own document, but I've been having to copy and paste over the data since I can only get the first row to merge.

I have attached screen shots of a sample table and a mock sheet of data so you can get a better visual. The name and loan amount merge earlier in the document and then the table is the last thing to merge. Is there a way to do this?

Please help!!!
Attached Images
File Type: png Mock Sheet.PNG (44.5 KB, 59 views)
File Type: png Table Example.PNG (3.5 KB, 60 views)
Reply With Quote