Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2015, 09:39 PM
AndyS AndyS is offline I want to create a lists within lists (nested merges) Mac OS X I want to create a lists within lists (nested merges) Office for Mac 2011
Novice
I want to create a lists within lists (nested merges)
 
Join Date: Dec 2015
Posts: 6
AndyS is on a distinguished road
Default

Ah! I was confused, I thought you were talking about a 'DATABASE' field in EXCEL!!

Yes, in WORD for Mac there are no 'Quick parts' but one can insert a DATABASE field with Insert -> Field -> Mailmerge -> Database.

I guess you are suggesting I create the Exhibitions table to look like a database (even in EXCEL?), then from the Mailmerge master document use a DATABASE field with an SQL query to generate the list of exhibitions for each Object? Can I use Object_id , the key to the record in the Mailmerge Object table, as a parameter in the query?



The SQL query would then do "Get me a table of all the exhibitions belonging to this object"?
I see there are some table formatting options in the field, but it is going to take some experimentation to get it right.

This does look like it might be a bit complicated for my relatively small application (119 records). What do you think of my suggestion in the previous post, to use intermediate mini-documents, themselves created by a mail merge with a bit of VBA to control the loop that creates an Exhibitions mini-document for each Object? I think this might give me more flexibility on formatting?
Reply With Quote
Reply

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 07:37 PM.


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