How to merge a 2nd or 3rd sheet from excel to word.

[Lauren Parsons]

Hi
I have excel speadsheets set up with multiple pages in
each file. I am havuing difficulty trying to merge from
either a second or third sheet. Whenever I try I only get
the data from sheet 1 in my merge. I am using Micrsoft
Word 2000 and have tried naming the different sheets but
the only option I ever get when I choose to open data
source is 'entire speadsheet'.

I'd be very grateful if you could shed somelight on this
one.

Many thanks
Lauren Parsons

 

[Peter Jamieson]

The default connection method (DDE) only sees the first sheet in the
spreadsheet, When you select the .xls file in the Open Data Source dialog
box, check the "Choose method" box, then select "Excel via ODBC". In the
subsequent dialog box, click the Options button and check all the boxes to
ensure you can see all the worksheet names and range names (if any), and
make sure the Excel file selected in the drop-down at the bottom of the
dialog box is for the .xls you selected in the Open Data Source dialog.

You will probably find that you need to use formatting switches in your Word
Mergefield fields to display the dates and any currency amounts correctly.

 

[Sheryl]

Hello Lauren.

I was having the same problem so I experimented and hide
the pages that I didnot want in the merge and wah lah, it
worked. Give it a try and let me know if it works for you
too.

Sheryl