How do I get mail merge to create multiple pages

[Nicole]

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.

 

[Peter Jamieson]

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

 

[Graham Mayor]

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

 

[Doug Robbins - Word MVP]

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


--
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