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?

 

Thanks!

Mim

 

Question Info


Last updated May 23, 2019 Views 8,423 Applies to:
Answer
Answer
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 http://www.gmayor.com/ManyToOne.htm  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)
For more Word tips and downloads visit my web site
https://www.gmayor.com/Word_pages.htm

1 person was 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.