[renee]

When merging from Excel 2007 to Word 2007 - only the first Excel page merges.
Cannot get it to pick up the entire Excel spreadsheet

[Peter Jamieson]

1. Do you mean that only the some of the records in a worksheet are merged?
If so, and you are doing a label merge, you are probably just previewing the
merge. You need to "complete" the merge, either by merging to a new document
or to a printer.

2. Or do you mean that your workbook contains several worksheets and the
merge is only taking data from one worksheet? If so, that is "by design",
i.e. out of the box, Word mailmerge can only use a single worksheet or named
range as a data source. If you want to use all the data in the workbook, it
is simplest to combine the data from all the worksheets into a new worksheet
and use that as the data source. (Something else can be done using Word VBA,
or at least it used to be possible, but it is much simpler to combine the
worksheet data in Excel)?

Or maybe you mean something else?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"RENEE" wrote in message
...
When merging from Excel 2007 to Word 2007 - only the first Excel page
merges.
Cannot get it to pick up the entire Excel spreadsheet

[renee]

Thank you so much! I was doing exactly what you said - I was previewing
without actually finishing the merge.

"RENEE" wrote:

When merging from Excel 2007 to Word 2007 - only the first Excel page merges.
Cannot get it to pick up the entire Excel spreadsheet