Name Badge Inserts with Mail Merge

[Redwoodelf22]

I'm working with Microsoft Word 2003 Student Edition and a name badge insert
template from avery.com (template 74549) and I was trying to find a way to
get the names on the name badges to fill in automatically.

The name badge template has 8 name badges per page and I've got
approximately 80 names on an Excel spread sheet. I though mail merge would
be the way to go to accomplish this and so I followed the instructions in
Word's help section and applied it to all the eight badges on the template
page. I was successful in getting this to work for the first badge in the
upper right hand corner of the page but the names are not inserting into the
other seven badges on the page. So it is giving me eighty pages of eight
badges where only the first one is filled out with a name. Is there
something I am doing wrong? Or is there a trick to telling the program to
put different names on all eight badges per page?

Thank you for your time!

 

[Beth Melton]

Did you follow the mail merge instructions for labels or form letters? When
you use Labels for your main document Word will insert a <Next Record>
field after your first record. It sounds like that's what you are missing.
Either from the Mail Merge toolbar, select Word Fields and insert the Next
Record field after your first set of merge fields or manually add it by
pressing Ctrl+F9 and then typing NEXT.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx