Mail Merge - To a Word Table on a Single Page

I am trying to Mail Merge multiple records using data extracted from an Excel 2010 Spreadsheet into the body of a table in Word 2010.


I want the records to "list" in the Word table on a single page, but everything I try ends up with 1 page and 1 table per record (multiple pages) instead of all on the same page in the same table.


Under the "Start Mail Merge", I have tried both Directory and Normal Word Document, but neither gives the outcome I'm trying to get.


Can anyone suggest what I might be doing wrong, please?




Word does not do Many to One merges. You have two choices. Either use a directory merge into a single row table (which will create a table containing all the records) and add it to the rest of the document later, or use a third party add-in such as my  which is not a true merge process but it will put data into a table in a merge document from a set of common records tied by a key field.
Graham Mayor (Microsoft Word MVP 2002-2019)
For more Word tips and downloads visit my web site

2 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated October 13, 2020 Views 17,777 Applies to: