Only 1 record per label sheet?

[Zack]

I am mail merging from excel file, and from outlook contacts, onto an avery
label sheet, but I get only one record per sheet in the top left corner. What
is the process for using the complete label sheet with the 20-25 address
label stickers on it?

 

[macropod]

Hi Zack,

If you used the mailmerge wizard to set up a labels merge, you should have a set of mergefields in every label. If not, you have two
choices:
1. re-do the merge set-up
2. copy the set of mergefields on the first label to all the other labels
This will give you a sheet full of the same label. If you want each label to pick up the next record, insert a NextRecord field at
the start of each label after the first.

 

[Doug Robbins - Word MVP]

It sounds like you have missed the step to replicate the setup of the merge
fields that you have inserted into the first cell of the table that forms
the labels to the other labels on the sheet.

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

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

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

http://www.gmayor.com/merge_labels_with_word_2007.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