Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 12-11-2015, 03:05 PM
macropod's Avatar
macropod macropod is offline I want to create a lists within lists (nested merges) Windows 7 64bit I want to create a lists within lists (nested merges) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

A directory/catalogue mailmerge working with your flattened workbook would be possible but, as is evident in the tutorial, adding extra subgroup keys increases the complexity. For two keys (e.g. Object_id and Exhibition_id), the examples in the tutorial would already suffice. For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

That said, the advantages of the DATABASE field include not having to flatten the workbook structure and automatically generating a table for the output. On its own, a directory/catalogue mailmerge doesn't work with multiple sheets and can't directly produce a single table for each group or subgroup.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
list within list, nested merge, vba mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to create a lists within lists (nested merges) Cant create any more numbered lists. rapid3642 Word 9 11-14-2014 08:28 PM
I want to create a lists within lists (nested merges) Need Serious Help with Outlines/Lists Stone Word 5 09-11-2012 04:56 PM
Numbered Lists jburtis Word 1 04-07-2012 02:42 PM
Distribution Lists WildBill Outlook 2 08-11-2011 08:15 AM
I want to create a lists within lists (nested merges) Searching dates to create lists brianh Excel 2 01-18-2010 01:58 PM

Other Forums: Access Forums

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


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