[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

"Nicole" wrote in message
...
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.

[Graham Mayor]

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

--

Graham Mayor - Word MVP

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

Peter Jamieson wrote:
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

"Nicole" wrote in message
...
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.

[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_lab...th_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

"Nicole" wrote in message
...
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.