label merge help!!

[stravers]

When I create a label merge document using an excel spreadsheet, Word only produces one page of labels. I end up having to copy and paste to create multiple pages. Isn't Word smart enough to produce enough labels for my entire data set? How do I fix this

THanks!!!

-stephe

 

[GRCC]

Yes stephen, "Word" is certainly smart enought to do multiple pages.
You should see a dialog box with fields to input the range of addresses or
all addresses. This should appear immediately prior to printing. You can
also select (in the same box) print to file, so you can preview the pages
before you print and after you are satisfied, print from there.
Hope this helps,
Frank l

When I create a label merge document using an excel spreadsheet, Word only

produces one page of labels. I end up having to copy and paste to create
multiple pages. Isn't Word smart enough to produce enough labels for my
entire data set? How do I fix this?

 

[Graham Mayor]

Of course it is. What we have here is pilot error
You need to complete the merge either to a new document or the printer. You
are looking at the merge source document.
See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Alan]

This is obscenely complicated

 

[Graham Mayor]

This is obscenely complicated

That's why I went to the trouble of preparing the web page with a pictorial
guide.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Graham Mayor]

You *still* haven't completed the merge. When you get to the complete merge
page, you either have to merge to the printer or choose 'edit individual
labels' which will create a multi-page document that you can edit or print.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>