![]() |
|
#2
|
||||
|
||||
|
When producing multiple tables, it would be better to use a series of DATABASE fields in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at:
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 (in the case the instructor name/id), 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: https://www.msofficeforums.com/mail-...-multiple.html https://www.msofficeforums.com/mail-...tml#post151706 Merge excel list into Word Receipt (the second of these uses a macro to apply some additional formatting - which may be pertinent in this case). The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: https://www.msofficeforums.com/mail-...html#post67097
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA code to CC multiple people in mail merge by word | kuankailok | Mail Merge | 3 | 05-04-2020 02:08 PM |
How to make MATCH/INDEX formula return multiple successive responses.
|
danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
| Task List Reports | dbsoccer | Outlook | 1 | 04-06-2013 06:33 AM |
Merge Reports...
|
DMA-Pacific | Word | 1 | 03-27-2012 11:49 PM |
| Sending multiple responses to an individual | ladeda16 | Outlook | 0 | 10-06-2009 03:18 PM |