Merge data in mutliple tabs in Excel sheet

[Lisa@Pru]

I have an Excel spreadsheet that has multiple sheets from which I need to
merge data into a Word doc. How do I get the merge process to acknowledge
multiple tabs?

I'm using Word 2000. When the merge wizard is envoked, I'm asked if I want
to use the entire spreadsheet, but it will only use the first tab.

Any thoughts?

Thanks!

 

[Doug Robbins - Word MVP]

Word can only use a single, flat file as a data source. You will need to
add another sheet to your workbook on which you link all of the data from
the other sheets that is required for the merge so that it is all in the one
place.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP