Merge - Word 2000 Excel 2000

[Kathy Saleeba]

I am doing a merge with the Excel document being my data
source. When I go through the wizard in Word (wish I
didn't have to use that blasted thing!) and I get to the
part to chose my data source, I chose the appropriate
file. The Excel spreadsheet has only one page to it,
however I get a list of 3 files to choose from:
kpa_address_list
kpa_address_list$
kpa_address_list_

When I chose the first one my merge was incomplete. I
only got 250 or so of almost 400 lines of data.

When I chose the second one, I got all my data merged.

WHY? WHY? WHY?

Thanks
Kathy

 

[Cindy M -WordMVP-]

Hi Kathy,

What you're seeing are named ranges in Excel (as in
Insert/Name, or the box at the very left of the formula
bar).

I am doing a merge with the Excel document being my data
source. When I go through the wizard in Word (wish I
didn't have to use that blasted thing!) and I get to the
part to chose my data source, I chose the appropriate
file. The Excel spreadsheet has only one page to it,
however I get a list of 3 files to choose from:
kpa_address_list
kpa_address_list$
kpa_address_list_

When I chose the first one my merge was incomplete. I
only got 250 or so of almost 400 lines of data.

When I chose the second one, I got all my data merged.

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