merge Word letters w/ Excel Workbook that has more than one sheet

[Irene]

When merging to a document in Word with an Excel workbook
that has more than one worksheet, how do you type in the
Excel source workbook in order to be able to use all
sheets of the workbook as the source and not just the
first worksheet of the workbook.

 

[Peter Jamieson]

Unfortunately Word can only use a single worksheet as the data source for a
merge, unless you use either MS Query and ODBC, or WOrd VBA to connect to
your sheet, in which case you can use a UNION query to get the data from all
the Worksheets.

But that is quite difficult to do and may not even be possible if you have
lots of sheets. A simpler workaround is probably to copy everything (perhaps
using some Excel VBA) into a single worksheet before mergeing.

 

[Cindy M -WordMVP-]

Hi Irene,

When merging to a document in Word with an Excel workbook
that has more than one worksheet, how do you type in the
Excel source workbook in order to be able to use all
sheets of the workbook as the source and not just the
first worksheet of the workbook.

Do you want to use all the sheets at once, or just be able
to select any one, particular sheet? Which version of Word
do you have?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail