Only 1 record per label sheet? Zack 11/28/2008 7:18:01 PM 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?

Re: Only 1 record per label sheet? "macropod" <macropod[ at ]invalid.invalid> 11/28/2008 8:53:33 PM 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. -- Cheers macropod [MVP - Microsoft Word] "Zack" <Zack[ at ]discussions.microsoft.com> wrote in message news:88CD3D60-0160-4C8A-8C0B-81C9CDA325E4[ at ]microsoft.com... [Quoted Text] >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?

Re: Only 1 record per label sheet? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/28/2008 8:58:12 PM 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 "Zack" <Zack[ at ]discussions.microsoft.com> wrote in message news:88CD3D60-0160-4C8A-8C0B-81C9CDA325E4[ at ]microsoft.com... [Quoted Text] >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?