Mail Merge - To a Word Table on a Single Page

Tables are usually only required when grouping data. This can be done using an ordinary letter merge containing a DATABASE field suitably coded for the table. All your data source needs is a separate sheet with rows containing a header and a single copy of each of the grouping criteria and any other fields you want to appear once per group. For example suppose you have a workbook named datasource.xlsx in the same folder as your mailmerge main document, with data like the following on Sheet1:

and you want to send a separate letter to each manager. In that case, you'd add another sheet (e.g. Sheet2) containing just:

then use this sheet (Sheet2) as the data source for your the mailmerge main document, to which you'd add a DATABASE field coded along the lines of:

{DATABASE \d "{FILENAME \p}/../MM datasource.xlsx" \s " SELECT [Subordinate Forename], [Subordinate Surname], [Subordinate ID], [Subordinate Job Title] FROM [Sheet1$] WHERE [Manager ID] = {MERGEFIELD Manager_ID} ORDER BY [Subordinate Job Title] " \l "15" \b "49" \h}

If the mailmerge main document is NOT kept in the same folder as the data source, you'd need to replace all of "{FILENAME \p}/../MM datasource.xlsx" with the full path & filename (plus the encompassing double-quotes). The \l and \b switches control the table format, while the \h switch insert a table header row - see: https://support.office.com/en-us/article/Field-codes-Database-field-04398159-a2c9-463f-bb59-558a87badcbc?ui=en-US&rs=en-US&ad=US

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.