Address labels - Creating new recipients in a merged document achyam 11/28/2008 3:08:00 AM 1. I wish to expand my recipients list in address labels merged document? I do not want to retype the whole thing again - just add the new ones. 2. I need to have the same individual recipients printed in groups of 10. I could not find procedure? Please advise. ------------------ Vista - Word 2003 - Avery Label J8651 [65/A4sheet]

Re: Address labels - Creating new recipients in a merged document "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/28/2008 5:17:40 AM Where is the data source for your existing labels? Either via the Mail Merge Wizard, the Mail Merge Toolbar or the original Mail Merge Helper, you can edit the data source by adding new records to it. 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 -- 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 "achyam" <achyam[ at ]discussions.microsoft.com> wrote in message news:9897D02E-0881-47D1-991A-A4083CD05AFE[ at ]microsoft.com... [Quoted Text] > 1. I wish to expand my recipients list in address labels merged document? > I do not want to retype the whole thing again - just add the new ones. > > 2. I need to have the same individual recipients printed in groups of > 10. > I could not find procedure? Please advise. > > ------------------ > Vista - Word 2003 - Avery Label J8651 [65/A4sheet]

Re: Address labels - Creating new recipients in a merged document "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 11/28/2008 6:51:24 AM And if your only source of data is the already merged label document - http://www.gmayor.com/convert_labels_into_mail_merge.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Doug Robbins - Word MVP wrote: [Quoted Text] > Where is the data source for your existing labels? > > Either via the Mail Merge Wizard, the Mail Merge Toolbar or the > original Mail Merge Helper, you can edit the data source by adding > new records to it. > 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 > > > > "achyam" <achyam[ at ]discussions.microsoft.com> wrote in message > news:9897D02E-0881-47D1-991A-A4083CD05AFE[ at ]microsoft.com... >> 1. I wish to expand my recipients list in address labels merged >> document? I do not want to retype the whole thing again - just add >> the new ones. 2. I need to have the same individual recipients printed >> in groups >> of 10. >> I could not find procedure? Please advise. >> >> ------------------ >> Vista - Word 2003 - Avery Label J8651 [65/A4sheet]

Re: Address labels - Creating new recipients in a merged document achyam 11/29/2008 3:39:00 AM Thank you Doug and Graham, I used "Convert Labels into Mail Merge Data Filed" from Gramham's site. I guess I can copy the first recipient to the next 9 address blocks then I will have my first group of 10. Then do this again for the second recipient and so-on. This will allow printing of labels in the groups. Ref part 2. of my original question. Thanks again. "Graham Mayor" wrote: [Quoted Text] > And if your only source of data is the already merged label document - > http://www.gmayor.com/convert_labels_into_mail_merge.htm > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > Doug Robbins - Word MVP wrote: > > Where is the data source for your existing labels? > > > > Either via the Mail Merge Wizard, the Mail Merge Toolbar or the > > original Mail Merge Helper, you can edit the data source by adding > > new records to it. > > 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 > > > > > > > > "achyam" <achyam[ at ]discussions.microsoft.com> wrote in message > > news:9897D02E-0881-47D1-991A-A4083CD05AFE[ at ]microsoft.com... > >> 1. I wish to expand my recipients list in address labels merged > >> document? I do not want to retype the whole thing again - just add > >> the new ones. 2. I need to have the same individual recipients printed > >> in groups > >> of 10. > >> I could not find procedure? Please advise. > >> > >> ------------------ > >> Vista - Word 2003 - Avery Label J8651 [65/A4sheet] > > >

Re: Address labels - Creating new recipients in a merged document "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/29/2008 5:30:16 AM If your label sheet has 10 labels on it, simply remove the <<Next Record>> fields from the mail merge main document (it will appear in cells 2 through 10). If the sheet has 20 labels. leave the <<Next Record>> field in the 11th label and if it has 30 labels, also leave it in the 21st label. -- 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 "achyam" <achyam[ at ]discussions.microsoft.com> wrote in message news:2434009A-47DE-4AC5-A42F-1289D63218F3[ at ]microsoft.com... [Quoted Text] > Thank you Doug and Graham, > I used "Convert Labels into Mail Merge Data Filed" from Gramham's site. > > I guess I can copy the first recipient to the next 9 address blocks then I > will have my first group of 10. Then do this again for the second > recipient > and so-on. > This will allow printing of labels in the groups. Ref part 2. of my > original > question. > Thanks again. > > > > "Graham Mayor" wrote: > >> And if your only source of data is the already merged label document - >> http://www.gmayor.com/convert_labels_into_mail_merge.htm >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> >> >> Doug Robbins - Word MVP wrote: >> > Where is the data source for your existing labels? >> > >> > Either via the Mail Merge Wizard, the Mail Merge Toolbar or the >> > original Mail Merge Helper, you can edit the data source by adding >> > new records to it. >> > 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 >> > >> > >> > >> > "achyam" <achyam[ at ]discussions.microsoft.com> wrote in message >> > news:9897D02E-0881-47D1-991A-A4083CD05AFE[ at ]microsoft.com... >> >> 1. I wish to expand my recipients list in address labels merged >> >> document? I do not want to retype the whole thing again - just add >> >> the new ones. 2. I need to have the same individual recipients >> >> printed >> >> in groups >> >> of 10. >> >> I could not find procedure? Please advise. >> >> >> >> ------------------ >> >> Vista - Word 2003 - Avery Label J8651 [65/A4sheet] >> >> >>