How do I get mail merge to create multiple pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole - 13 Oct 2006 21:50 GMT

I am transferring data from Excel to Mail Merge in word for labels and I only
get 1 page of data when I should have more like 30.

Reply to this Message

Peter Jamieson - 13 Oct 2006 22:47 GMT

You are probably doing one of the following:
a. using the print icon in Word's toolbar, or File|Print, rather than
merging to the printer.
b. getting nearly to the last step in the merge, then not "completing" it,
and just seeing one page of labels in the preview.

If you are using the Mail Merge Wizard, and you have got to the last pane of
the Wizard, you should have options either to print the results or "edit the
individual labels". If you click that print option, the labels should be
printed. If you edit the individual labels, Word should create a new
document containing all the labels.

Peter Jamieson

>I am transferring data from Excel to Mail Merge in word for labels and I
>only
> get 1 page of data when I should have more like 30.

Reply to this Message

Graham Mayor - 14 Oct 2006 06:21 GMT

This is also explained with illustrations at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> You are probably doing one of the following:
> a. using the print icon in Word's toolbar, or File|Print, rather than
[quoted text clipped - 13 lines]
>> and I only
>> get 1 page of data when I should have more like 30.

Reply to this Message

Doug Robbins - Word MVP - 14 Oct 2006 06:23 GMT

See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am transferring data from Excel to Mail Merge in word for labels and I
>only
> get 1 page of data when I should have more like 30.

Reply to this Message