Merging Excel as labels problem

[BigBlueMan]

I have 950 names and addresses in an Excel file. I'm trying to merge it
into Word to create mailing labels using Merge Wizard.

I can do so with no problem, but it only does one page of labels
(approximately 30), when I should have MANY pages. I can't find any setting
to expand on this.

Any help would be appreciated.

ed

 

[Peter Jamieson]

Are you actually performing the merge (if you have got to the point where
you are seeing a preview of the labels, it isn't enough just to do
FIle|Print - you have to go to Step 6 in the Mail Merge Wizard and either
choose the Print option there, or "Edit individual labels", in which case
the merge results are output to a new document which you can then edit
and/or print.

 

[JD]

I also encountered this problem, but there is an easy
remedy.

First you need to have the "Mail Merge" toolbar activated
(right click in top bar and select). After you have
arranged your labels from your list and clicked "Update
all labels" with all records, then from the toolbar you
want to select "Merge to New Document". With 950 names on
it, it may take a while after only showing the first page,
but soon you should see all 950 labels.

Hope that works for you. I personally am not liking
2002/XP very much.

 

[Dale]

I have about 1400 names and addresses. Merging into Word
I have problems with it recognizing my sorting. Have you
just gone ahead and printed? My print preview will only
show one page, but more are printed. Of course, my last 3
pages disappear and I'm still working on that problem.