How can I print a full page of the same label using Mail Merge fields? I
have a spreadsheet with hundreds of lines. I would like to select specific
lines and print a full page of labels for each of the selected lines.

I have only been able to figure out how to print one of each of the selected
labels.

Each time I print, I will select only the lines that are needed that run,
but will need a full page each time.

If you omit the Next Record field in every label but the last, you'll get a
new record for the first label on each sheet and no others.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"seansmom" wrote in message
...
How can I print a full page of the same label using Mail Merge fields? I
have a spreadsheet with hundreds of lines. I would like to select
specific
lines and print a full page of labels for each of the selected lines.

I have only been able to figure out how to print one of each of the
selected
labels.

Each time I print, I will select only the lines that are needed that run,
but will need a full page each time.

Hi ?B?c2VhbnNtb20=?=,

After you've set up the merge sheet, press alt+F9 to display the field codes.
You'll notice a { NEXT } code in the second and following labels. You need to
delete the NEXT fields from the label sheet.

The fastest way would be to use Find/Replace:
Find text: ^d NEXT
Replace: [leave it empty]

How can I print a full page of the same label using Mail Merge fields? I
have a spreadsheet with hundreds of lines. I would like to select specific
lines and print a full page of labels for each of the selected lines.

I have only been able to figure out how to print one of each of the selected
labels.

Each time I print, I will select only the lines that are needed that run,
but will need a full page each time.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)