Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]() "Relztrah" wrote: 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. |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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" wrote in message ... 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. |
#4
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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" wrote in message ... 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. |
#5
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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" wrote in message ... 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. |
#6
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... 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. |
#7
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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" wrote in message ... 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" wrote in message ... 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. |
#8
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
You could use the old Mailmerge Helper - covered at
http://www.gmayor.com/mail_merge_lab...th_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: 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" wrote in message ... 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" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I change recipients details in a merge recipients list | Mailmerge | |||
Checkboxes on mailmerge recipients list | Mailmerge | |||
mailmerge recipients | Mailmerge | |||
How do I make a list of people from an *.mdb recipients list | Mailmerge | |||
Printing a list of recipients from a mail merge list | Microsoft Word Help |