![]() |
#7
|
|||
|
|||
![]()
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? |
Tags |
list within list, nested merge, vba mail merge |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rapid3642 | Word | 9 | 11-14-2014 08:28 PM |
![]() |
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 |
![]() |
brianh | Excel | 2 | 01-18-2010 01:58 PM |