merge from only one worksheet in a workbook.

[JG]

I have a workbook with worksheets for each of the past four years. I
need to print labels from just one of the worksheets, how can I do this?
Using Office 2000 on WinXP.

 

[Peter Jamieson]

You can't do it using the default connection method in Word 2000 (DDE). In
the Open Data Source dialog box, select the workbook then check Select
Method. Then I'd choose the Excel via ODBC option if you see it. Then you
will see a dialog box listing the "tables". If you still only see one sheet,
a. check that the file name listed in the drop-down at the bottom right of
the dialog box is the correct file - it may not be
b. click the Options button and check all the boxes
c. you should see all the sheets - pick the one you want.

 

[Cindy Meister -WordMVP-]

Hi Jg,

I have a workbook with worksheets for each of the past four years. I
need to print labels from just one of the worksheets, how can I do this?
Using Office 2000 on WinXP.

In the "Open data source" dialog box, activate the "Select method"
checkbox.
In the list that follows clicking OK, choose "ODBC"
In the subsequent dialog box, click Options, then activate the checkboxes
that will appear.
Now you should see a list of worksheets, as well as named ranges.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 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

 

[JG]

Thanks, I'll try the suggestion(s). However, I've discovered that
Publisher is a lot easier to use doing mail merges, and it's also easier
to set up to add a graphic/return address without having to jump through
a ton of hoops.