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 - 13 Apr 2004 16:47 GMT
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?
> THanks!!!!
>
> -stephen
Graham Mayor - 13 Apr 2004 16:56 GMT
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

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
> 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
[quoted text clipped - 4 lines]
>
> -stephen
Alan - 16 Apr 2004 22:16 GMT
This is obscenely complicated
Graham Mayor - 17 Apr 2004 08:24 GMT
> This is obscenely complicated
That's why I went to the trouble of preparing the web page with a pictorial
guide.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<