Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
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
 

Tags
list within list, nested merge, vba mail merge



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 04:41 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