Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Refreshing mailmerge document
I'm using Word 2002.
I have made a mailmerge with the mail merge wizard. The file I use to select from, is a query in access 2002. To narrow down the recipients I filtered for a certain city. Finally I saved the file to a new document with for instance the name London. Several persons moved, and the database was changed to reflect the new address (city). However when I opened the file London, I noticed that the addresses were not changed. So the file is only a snapshot. Is there a way that I can repeat the same merge without having to go through all the steps again? Ricky |
#2
|
|||
|
|||
Refreshing mailmerge document
If you save your document before doing the merge, possibly saving as a
template, then perform a merge when you want to update, I think you'll get what you want. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Ricky Gibson" wrote in message . .. I'm using Word 2002. I have made a mailmerge with the mail merge wizard. The file I use to select from, is a query in access 2002. To narrow down the recipients I filtered for a certain city. Finally I saved the file to a new document with for instance the name London. Several persons moved, and the database was changed to reflect the new address (city). However when I opened the file London, I noticed that the addresses were not changed. So the file is only a snapshot. Is there a way that I can repeat the same merge without having to go through all the steps again? Ricky |
#3
|
|||
|
|||
Refreshing mailmerge document
You should still have the main Word document you created for the
original mail-merge -- the one in which you inserted the merge fields like «FirstName», «LastName» and «City». If you re-open that, it should still be connected to the same file you used as your database. Just run another merge, using the same query to return only records with London in the city field, and you'll get the same letter, only addressed to people who're currently listed as being in London. Alternatively, you can either edit your main document or create a new one using the same database and send out an updated letter. Steve Ricky Gibson wrote: I'm using Word 2002. I have made a mailmerge with the mail merge wizard. The file I use to select from, is a query in access 2002. To narrow down the recipients I filtered for a certain city. Finally I saved the file to a new document with for instance the name London. Several persons moved, and the database was changed to reflect the new address (city). However when I opened the file London, I noticed that the addresses were not changed. So the file is only a snapshot. Is there a way that I can repeat the same merge without having to go through all the steps again? Ricky |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros and SharePoint WSS document libraries | New Users | |||
SQL Prompt When opening merged documents | Mailmerge | |||
Can you save individual document pages as seperate word files? | Mailmerge | |||
Problems migrating Word 97 mailmerge document to Word 2003 | Mailmerge | |||
Newbie document question please | New Users |