Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2020, 02:46 PM
TeresaRyanKS TeresaRyanKS is offline Nesting Tables in a Merge Document Windows 7 64bit Nesting Tables in a Merge Document Office 2010
Novice
Nesting Tables in a Merge Document
 
Join Date: Jan 2020
Posts: 2
TeresaRyanKS is on a distinguished road
Default 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.
Attached Files
File Type: docx TM Status Merge Document.docx (16.1 KB, 1 views)
File Type: docx TM Status Desired Results.docx (15.1 KB, 2 views)
Reply With Quote
  #2  
Old 02-03-2020, 09:33 PM
macropod's Avatar
macropod macropod is offline Nesting Tables in a Merge Document Windows 7 64bit Nesting Tables in a Merge Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,900
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-04-2020, 12:09 PM
TeresaRyanKS TeresaRyanKS is offline Nesting Tables in a Merge Document Windows 7 64bit Nesting Tables in a Merge Document Office 2010
Novice
Nesting Tables in a Merge Document
 
Join Date: Jan 2020
Posts: 2
TeresaRyanKS is on a distinguished road
Default

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!
Reply With Quote
Reply

Thread Tools
Display Modes


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 Tables in a Merge Document 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 Tables in a Merge Document Nesting Variables SET, LISTNUM, and REF Wyskers Word 1 11-13-2011 05:43 AM


All times are GMT -7. The time now is 11:12 AM.


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