merge XL data into labels

[Guest]

I have data entered an Excel Spreadsheet with appropriate headings to perform
the merge to address labels in Word.
However when I perform the merge and go to porint what should be 30 or so
labels (*note: I am using 5160 template format which allows up to 30 labels
per sheet) on what should be 2 shets, there ends up being well more than
those 2 sheets.
Am I doing something incorrect? Pls advise/ HELP! Thank you in advanced.

 

[Doug Robbins - Word MVP]

What are you actually getting on the sheets? - Multiple copies of the same
label?

There should be a <<Next Record>> field before the first merge field in all
of the labels on the mail merge main document, EXCEPT for the first label on
the sheet.

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

 

[Graham Mayor]

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

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>