How do I add recipients to a mailmerge label list? Relztrah 12/18/2008 6:56:19 PM This should be very simple. I created address labels using Word mailmerge and finished the merge, printed the labels, everything's OK. Now I want to add new recipients to my existing .mdb file and re-merge. I can open the original document and edit the existing recipients, but how do I actually add new names and addresses? There is no button on the Mailmerge toolbar to ADD recipients. Please provide simple step-by-step instructions because I have tried everything and can't seem to open my existing data file so that I can add names and addresses, only edit the existing ones.

RE: How do I add recipients to a mailmerge label list? Relztrah 12/18/2008 7:00:14 PM "Relztrah" wrote: [Quoted Text] > This should be very simple. I created address labels using Word mailmerge and > finished the merge, printed the labels, everything's OK. Now I want to add > new recipients to my existing .mdb file and re-merge. I can open the original > document and edit the existing recipients, but how do I actually add new > names and addresses? There is no button on the Mailmerge toolbar to ADD > recipients. > > Please provide simple step-by-step instructions because I have tried > everything and can't seem to open my existing data file so that I can add > names and addresses, only edit the existing ones. >I am using Word 2003.

Re: How do I add recipients to a mailmerge label list? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/18/2008 7:37:07 PM Open the mdb file with Excel, and add the new names and addresses and save the file as an Excel Workbook and use that as your data source. -- 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 "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message news:FD595E6A-9477-4ED6-8C92-C59A8EE5C090[ at ]microsoft.com... [Quoted Text] > This should be very simple. I created address labels using Word mailmerge > and > finished the merge, printed the labels, everything's OK. Now I want to add > new recipients to my existing .mdb file and re-merge. I can open the > original > document and edit the existing recipients, but how do I actually add new > names and addresses? There is no button on the Mailmerge toolbar to ADD > recipients. > > Please provide simple step-by-step instructions because I have tried > everything and can't seem to open my existing data file so that I can add > names and addresses, only edit the existing ones.

Re: How do I add recipients to a mailmerge label list? "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/18/2008 11:45:27 PM Try "Mail Merge Recipients", then click the Edit button in there. If the Edit button is greyed out it (usually) means that Word does not recognise your .mdb as an "Office Address List" any more, in which case you can edit the recipients list directly in Access (if you have it) or go the route that Doug suggested. -- Peter Jamieson http://tips.pjmsn.me.uk "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message news:FD595E6A-9477-4ED6-8C92-C59A8EE5C090[ at ]microsoft.com... [Quoted Text] > This should be very simple. I created address labels using Word mailmerge > and > finished the merge, printed the labels, everything's OK. Now I want to add > new recipients to my existing .mdb file and re-merge. I can open the > original > document and edit the existing recipients, but how do I actually add new > names and addresses? There is no button on the Mailmerge toolbar to ADD > recipients. > > Please provide simple step-by-step instructions because I have tried > everything and can't seem to open my existing data file so that I can add > names and addresses, only edit the existing ones.

Re: How do I add recipients to a mailmerge label list? Relztrah 12/19/2008 4:40:01 AM Please note that I don't want to edit my current list. I want to ADD recipients to an existing list and perform the merge again. Are you saying that I cannot do this in Word? I have to use Access or Excel to add names to a mailing label merge job in Word? "Peter Jamieson" wrote: [Quoted Text] > Try "Mail Merge Recipients", then click the Edit button in there. > > If the Edit button is greyed out it (usually) means that Word does not > recognise your .mdb as an "Office Address List" any more, in which case you > can edit the recipients list directly in Access (if you have it) or go the > route that Doug suggested. > > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message > news:FD595E6A-9477-4ED6-8C92-C59A8EE5C090[ at ]microsoft.com... > > This should be very simple. I created address labels using Word mailmerge > > and > > finished the merge, printed the labels, everything's OK. Now I want to add > > new recipients to my existing .mdb file and re-merge. I can open the > > original > > document and edit the existing recipients, but how do I actually add new > > names and addresses? There is no button on the Mailmerge toolbar to ADD > > recipients. > > > > Please provide simple step-by-step instructions because I have tried > > everything and can't seem to open my existing data file so that I can add > > names and addresses, only edit the existing ones. > >

Re: How do I add recipients to a mailmerge label list? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/19/2008 5:36:42 AM That is what we have said to-date. However, if you use your existing datasource with a Directory type mailmerge main document in which you insert the merge fields into the cells of a one row table, with nothing else in the documnet, and then you execute that merge to a new document, that new document will contain a table with a row of data for each record in your data source. You can then insert a row at the top of the table into which you insert the names of the merge fields and you can then add addtional rows to the table and populate those rows with the new records. Then save that document and use it as the data source for your merge. Seems to me that just opening the existing file in Excel would be easier. -- 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 "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message news:73B03040-9157-430A-8DFC-8A7EC6EC45C2[ at ]microsoft.com... [Quoted Text] > Please note that I don't want to edit my current list. I want to ADD > recipients to an existing list and perform the merge again. Are you saying > that I cannot do this in Word? I have to use Access or Excel to add names > to > a mailing label merge job in Word? > > "Peter Jamieson" wrote: > >> Try "Mail Merge Recipients", then click the Edit button in there. >> >> If the Edit button is greyed out it (usually) means that Word does not >> recognise your .mdb as an "Office Address List" any more, in which case >> you >> can edit the recipients list directly in Access (if you have it) or go >> the >> route that Doug suggested. >> >> -- >> Peter Jamieson >> http://tips.pjmsn.me.uk >> >> "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message >> news:FD595E6A-9477-4ED6-8C92-C59A8EE5C090[ at ]microsoft.com... >> > This should be very simple. I created address labels using Word >> > mailmerge >> > and >> > finished the merge, printed the labels, everything's OK. Now I want to >> > add >> > new recipients to my existing .mdb file and re-merge. I can open the >> > original >> > document and edit the existing recipients, but how do I actually add >> > new >> > names and addresses? There is no button on the Mailmerge toolbar to ADD >> > recipients. >> > >> > Please provide simple step-by-step instructions because I have tried >> > everything and can't seem to open my existing data file so that I can >> > add >> > names and addresses, only edit the existing ones. >> >>

Re: How do I add recipients to a mailmerge label list? "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/19/2008 8:56:22 AM The Edit button leads you to a dialog box that lets you add records. If the Edit button is greyed, you cannot use that method for the reason I mentioned. I do not believe that there is a more direct way to go to this Edit/Add function in Word 2003, at least not that works with an "Office Address Book" ..mdb file. -- Peter Jamieson http://tips.pjmsn.me.uk "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message news:73B03040-9157-430A-8DFC-8A7EC6EC45C2[ at ]microsoft.com... [Quoted Text] > Please note that I don't want to edit my current list. I want to ADD > recipients to an existing list and perform the merge again. Are you saying > that I cannot do this in Word? I have to use Access or Excel to add names > to > a mailing label merge job in Word? > > "Peter Jamieson" wrote: > >> Try "Mail Merge Recipients", then click the Edit button in there. >> >> If the Edit button is greyed out it (usually) means that Word does not >> recognise your .mdb as an "Office Address List" any more, in which case >> you >> can edit the recipients list directly in Access (if you have it) or go >> the >> route that Doug suggested. >> >> -- >> Peter Jamieson >> http://tips.pjmsn.me.uk >> >> "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message >> news:FD595E6A-9477-4ED6-8C92-C59A8EE5C090[ at ]microsoft.com... >> > This should be very simple. I created address labels using Word >> > mailmerge >> > and >> > finished the merge, printed the labels, everything's OK. Now I want to >> > add >> > new recipients to my existing .mdb file and re-merge. I can open the >> > original >> > document and edit the existing recipients, but how do I actually add >> > new >> > names and addresses? There is no button on the Mailmerge toolbar to ADD >> > recipients. >> > >> > Please provide simple step-by-step instructions because I have tried >> > everything and can't seem to open my existing data file so that I can >> > add >> > names and addresses, only edit the existing ones. >> >>

Re: How do I add recipients to a mailmerge label list? "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/19/2008 2:02:47 PM You could use the old Mailmerge Helper - covered at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm - which will allow you to break the link with the MDB file and create a new document containing the data which can be edited and used as the data source in place of the MDB file. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Peter Jamieson wrote: [Quoted Text] > The Edit button leads you to a dialog box that lets you add records. > If the Edit button is greyed, you cannot use that method for the > reason I mentioned. > > I do not believe that there is a more direct way to go to this > Edit/Add function in Word 2003, at least not that works with an > "Office Address Book" .mdb file. > > > "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message > news:73B03040-9157-430A-8DFC-8A7EC6EC45C2[ at ]microsoft.com... >> Please note that I don't want to edit my current list. I want to ADD >> recipients to an existing list and perform the merge again. Are you >> saying that I cannot do this in Word? I have to use Access or Excel >> to add names to >> a mailing label merge job in Word? >> >> "Peter Jamieson" wrote: >> >>> Try "Mail Merge Recipients", then click the Edit button in there. >>> >>> If the Edit button is greyed out it (usually) means that Word does >>> not recognise your .mdb as an "Office Address List" any more, in >>> which case you >>> can edit the recipients list directly in Access (if you have it) or >>> go the >>> route that Doug suggested. >>> >>> -- >>> Peter Jamieson >>> http://tips.pjmsn.me.uk >>> >>> "Relztrah" <Relztrah[ at ]discussions.microsoft.com> wrote in message >>> news:FD595E6A-9477-4ED6-8C92-C59A8EE5C090[ at ]microsoft.com... >>>> This should be very simple. I created address labels using Word >>>> mailmerge >>>> and >>>> finished the merge, printed the labels, everything's OK. Now I >>>> want to add >>>> new recipients to my existing .mdb file and re-merge. I can open >>>> the original >>>> document and edit the existing recipients, but how do I actually >>>> add new >>>> names and addresses? There is no button on the Mailmerge toolbar >>>> to ADD recipients. >>>> >>>> Please provide simple step-by-step instructions because I have >>>> tried everything and can't seem to open my existing data file so >>>> that I can add >>>> names and addresses, only edit the existing ones.