#1
|
|||
|
|||
Nesting Tables in a Merge Document
I created the attached merge document consisting of a main table to contain information regarding one trademark matter and a nested table to contain the deadlines associated with that trademark. This nested table will sometimes contain multi-lines of data.
My data file is an Excel spreadsheet which contains a line item for each matter. If a matter has more than one deadline, it will have two line items. How do I prepare the merge document to include multi-line data in the nested table? Also attached is an example of the desired results. Any assistance is appreciated. |
#2
|
||||
|
||||
You may be able to get the desired results by inserting a DATABASE field into your main table and using that to generate the nested table. For some general guidance, see:
Many to one email merge using tables - Microsoft Community If you're using a relational database or, Excel workbook with a separate table with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at: Mail Merge - To a Word Table on a Single Page - Microsoft Community For some working examples, see: Mail Merge: Using One Excel File with Multiple Sheets Merge excel list into Word Receipt Although none of these use nested tables, the principles are the same.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you for your reply. I am reviewing the information provided to see if I can put it into practice.
Thanks again for your review and comments! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
INDEX and MATCH nesting with if | Peter Simpson | Excel Programming | 1 | 05-27-2019 06:53 AM |
Nesting Merge Fields | LearningMom | Mail Merge | 9 | 09-25-2017 01:44 PM |
Nesting and IF & AND statement | lynchbro | Excel | 4 | 04-16-2015 11:39 AM |
Script starts nesting tables without reason | selman555 | Word VBA | 1 | 10-17-2014 01:01 AM |
Nesting Variables SET, LISTNUM, and REF | Wyskers | Word | 1 | 11-13-2011 05:43 AM |