[WMgirl]

I have an Excel database to be merged into Word 2007 for labels. The first
time I did the labels, there were over 1000 and all merged just fine. For
this mailing, I have reduced the database to 997 but only the first 48 of the
names will merge. What is going on? I need help quickly. My client expects
this project yesterday, of course.

[Peter Jamieson]

1. Are there any empty rows in the sheet (e.g. a hidden row after row 48/49)
?
2. Are you still "merging" rather than e.g. printing to a 48-label sheet?
You have to "complete the merge" - if you don't you'll just see a single
sheet. (Doesn't sound like that to me)
3. When you go through the data source selection process in Word, are you
seeing any names in the list of "tables" other than the sheet name? If you
have also defined any Excel Range Names that reference part of the sheet,
and you used a name similar to the Sheet name, make sure you select the
Sheet and not the Range name. (Doubt if it's that eiher but it's all I can
think of right now)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"WMgirl" wrote in message
...
I have an Excel database to be merged into Word 2007 for labels. The first
time I did the labels, there were over 1000 and all merged just fine. For
this mailing, I have reduced the database to 997 but only the first 48 of
the
names will merge. What is going on? I need help quickly. My client expects
this project yesterday, of course.

[WMgirl]

1. No empty rows anywhere.
2. I know that depending on where I view the results, I'll either see the
first page of all it; even in "edit" in Word all I could see was 48 rows as
if the rest didn't exist.
3. I referenced the entire sheet not just part of it.

I got an error message at one point that said the file was corrupt when Word
tried to use it for the merge. That's when I copied and pasted the sheet from
Excel to Word and used it for the merge. I saved it as a Word file and was
able to get the blasted thing finished and off to my client. Whew! Thanks for
your help, James, I'll keep your suggestions handy for the next merge I do.
Until this time, I didn't know an empty row would stop the merge. A simple
thing.

"Peter Jamieson" wrote:

1. Are there any empty rows in the sheet (e.g. a hidden row after row 48/49)
?
2. Are you still "merging" rather than e.g. printing to a 48-label sheet?
You have to "complete the merge" - if you don't you'll just see a single
sheet. (Doesn't sound like that to me)
3. When you go through the data source selection process in Word, are you
seeing any names in the list of "tables" other than the sheet name? If you
have also defined any Excel Range Names that reference part of the sheet,
and you used a name similar to the Sheet name, make sure you select the
Sheet and not the Range name. (Doubt if it's that eiher but it's all I can
think of right now)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"WMgirl" wrote in message
...
I have an Excel database to be merged into Word 2007 for labels. The first
time I did the labels, there were over 1000 and all merged just fine. For
this mailing, I have reduced the database to 997 but only the first 48 of
the
names will merge. What is going on? I need help quickly. My client expects
this project yesterday, of course.