Hi,



Can somebody help me with this problem?

I have a table in Excel with data. I have a word document with text and in the middle of the text I have to merge data from excel as a table. I know how to work with mail merge, but to get separate page for each record/row from Excel.

This time I need to get all data from excel table in word as a table and to get one page, instead to get 10 separate pages in word.

If somebody wants to help me, I would be very grateful to you.

Best regards

The simplest way to do this is to copy & paste the Excel table into Word where you want it to appear. No mailmerge required. If you paste the data using the Paste Special>Paste Link option and the data source uses a named range, the document will update to reflect any changes to that named range.

Adding body content before & after the merged records, but not between them, requires some complex field coding.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you very much for advice.