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!!!
|