Data source Excel multiple files?

[KSaleeba]

I did a merge yesterday in Word 2000 and had a situation
arise I didn't understand. Using the Word merge wizard,
when I got to the step to choose my data source file, I
chose the appropriate file, which was a one page Excel
spreadsheet. However, I had three choices presented to
me:

kpa_address_a.xls
kpa_address_a$.xls
kpa_address_a_.xls

I chose the first one, but when I looked at it in select
recipients step, only about 2/3 of the names showed.
When I used the second file ($) it merged fine. Can
someone please explain to me the differences in these
files. I suspect, after doing some research that these
may be for "different" flavors of Excel to Word,(such as
ODBC connectors) but would like a verification or the
correct answer. Thanks.

 

[Cindy M -WordMVP-]

Hi KSaleeba,

When you set up an ODBC merge you'll be offered all the
NAMED RANGES available in your workbook as merge sources. I
can't tell you what created these named ranges, although if
you used Excel's "data form" that may have something to do
with it.

Click in the "name box" at the very left side of the Excel
formula bar and you should see a list or range names. Or go
to Insert/Name/Define to see a list.

I did a merge yesterday in Word 2000 and had a situation
arise I didn't understand. Using the Word merge wizard,
when I got to the step to choose my data source file, I
chose the appropriate file, which was a one page Excel
spreadsheet. However, I had three choices presented to
me:

kpa_address_a.xls
kpa_address_a$.xls
kpa_address_a_.xls

I chose the first one, but when I looked at it in select
recipients step, only about 2/3 of the names showed.
When I used the second file ($) it merged fine. Can
someone please explain to me the differences in these
files. I suspect, after doing some research that these
may be for "different" flavors of Excel to Word,(such as
ODBC connectors) but would like a verification or the
correct answer. Thanks.

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