How can I mail merge labels so that the same name repeats across . autumnleaves08 10/24/2008 3:38:39 PM I am creating a mailmerge of student first and last names on a label. I would like to create each row of labels with the same student's name going across. My sheet has 4 labels across - i.e. Mary Jones Mary Jones Mary Jones Mary Jones and then another name repeat across for the second row, and so on. Is there any way to do this? Thank you!

Re: How can I mail merge labels so that the same name repeats across . "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 10/24/2008 3:54:38 PM Create the Label merge, enter the fields that you want in the first label, then "propagate the labels" in the usual way At this point if you use Alt-F9 you should be able to see that each "label" has a number of { MERGEFIELD } fields and every label has a { NEXT } field except the very first one on the sheet. Delete the { NEXT } fields in columns 2, 3 and 4. Save your mail merge main document. Test by merging to a new document. -- Peter Jamieson http://tips.pjmsn.me.uk "autumnleaves08" <autumnleaves08[ at ]discussions.microsoft.com> wrote in message news:C08F5497-B5D5-4E98-A7F9-D918F8607174[ at ]microsoft.com... [Quoted Text] >I am creating a mailmerge of student first and last names on a label. I > would like to create each row of labels with the same student's name going > across. My sheet has 4 labels across - i.e. Mary Jones Mary Jones > Mary > Jones Mary Jones > and then another name repeat across for the second row, and so on. Is > there > any way to do this? > Thank you!

Re: How can I mail merge labels so that the same name repeats across . "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 10/25/2008 6:24:29 AM Having done what Peter suggests note that some versions of Word will contrive to put back the missing next fields if you leave the document as a label format document. You can avoid this, if it becomes an issue, by changing the merge document type to 'Letter' before removing the unwanted Next fields. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Peter Jamieson wrote: [Quoted Text] > Create the Label merge, enter the fields that you want in the first > label, then "propagate the labels" in the usual way > > At this point if you use Alt-F9 you should be able to see that each > "label" has a number of { MERGEFIELD } fields and every label has a { > NEXT } field except the very first one on the sheet. > > Delete the { NEXT } fields in columns 2, 3 and 4. > > Save your mail merge main document. > > Test by merging to a new document. > > "autumnleaves08" <autumnleaves08[ at ]discussions.microsoft.com> wrote in > message news:C08F5497-B5D5-4E98-A7F9-D918F8607174[ at ]microsoft.com... >> I am creating a mailmerge of student first and last names on a >> label. I would like to create each row of labels with the same >> student's name going across. My sheet has 4 labels across - i.e. >> Mary Jones Mary Jones Mary >> Jones Mary Jones >> and then another name repeat across for the second row, and so on. Is >> there >> any way to do this? >> Thank you!