Help with merging 1 address to many files

[FL Consultant]

We use mailmerge to create contract files using one file, the contract, with
many addresses.

Now we want to have many contract files but only use one address. So that
the same name or address appears on many contracts.

Can we use mailmerge and how do we do that or do we need to another solution
and what would that be?

Thank you

 

[Doug Robbins]

Not mailmerge, but something like the article "Find & ReplaceAll on a batch
of documents in the same folder" at:

http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

should be able to do what you want.

--
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

 

[FL Consultant]

Doug,
Thanks for the excellent suggestion. That will work for updating one thing
but I should have stated that we might need to change or add more than one
item suppose we need multiple fields changed. How would we do that?

Thanks

 

[Doug Robbins]

Run it as many times as necessary or or modify it so that it handles
multiple replacements.

--
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

 

[FL Consultant]

The last solution will not work. I see that maybe the initial question was
not worded in a way that best described the problem. Your solution was good
for a change of one field but when we need to change a document(s) that has
many fields that need data updated your solution though it will work is not
efficient.

Let me state the problem again. We have lets say 5 (though the number is
much larger) different contracts that require the same piece of data placed
on each of them. This data may consist of a name, address, date, number of
stores and other information. The information will be the same for each
contract. We would like to use mailmerge or some thing like mailmerge to
perform this task. Some way that will allow us to automate the process and
be able to run it once when we need to update a contracts. The documents
(contracts) will be in a word format.

Thanks

 

[Doug Robbins]

Mailmerge is really designed for inserting many instances of the same data
into a single document to create multiple instances of that document. What
you want to do is in one instance of some data into many documents which is
quite different. So mailmerge is not the thing to use. At least not the
best thing.

The code in the item to which I pointed you can however be modified to do
what you want. As this would appear to be required for commerical purposes,
if you do not have the knowledge to do that, then you may have to consider
paying someone to do it for you.

--
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

The last solution will not work. I see that maybe the initial question
was
not worded in a way that best described the problem. Your solution was
good
for a change of one field but when we need to change a document(s) that
has
many fields that need data updated your solution though it will work is
not
efficient.

Let me state the problem again. We have lets say 5 (though the number is
much larger) different contracts that require the same piece of data
placed
on each of them. This data may consist of a name, address, date, number
of
stores and other information. The information will be the same for each
contract. We would like to use mailmerge or some thing like mailmerge to
perform this task. Some way that will allow us to automate the process
and
be able to run it once when we need to update a contracts. The documents
(contracts) will be in a word format.

Thanks

 

[Anne Troy]

You might want to try this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=381
That code only pushes to one file, but I'm sure you could make it push to
several.
*******************
~Anne Troy

www.OfficeArticles.com

 

[FL Consultant]

Thank you for the suggestion. Though the documents are in tied to a
MailMerge format because they are used to also merge many contacts to one
form. But I appreciate the suggestion.

I have been able to locate the MailMergeField and desplay the field. There
must be a method that allows you to add text to a document. If there is I
could print or save as the changed document which would give me the results I
am looking for and also keep my original documents to be used for another
mail merge.

Thanks for responding.

 

[Peter Jamieson]

Though I agree with Doug in broad terms, if you already have mailmerge
documents set up it's more a question of
a. creating the data source you need
b. connecting the merge documents to the single data record you need and
performing the merge
b. automating the complete set of merges - you might for example either
process each document in a a particular folder or tree of folders, or
maintain a separate list and process that somehow.
c. paying some attention to saving your output documents, if you need to
save precisely what you produced (you need to do this whatever approach you
use if you are relying on machine-readable versions of documents for any
sort of legal purpose)

The problem with (a) is that if you already have merge main documents set up
to get their data from particular data sources, unless you make copies of
these documents and permanently each copy to the data source you need, each
time you use the mail merge main documents you will have to ensure that they
are connected to the correct data source for the purpose.

Peter Jamieson

The last solution will not work. I see that maybe the initial question
was
not worded in a way that best described the problem. Your solution was
good
for a change of one field but when we need to change a document(s) that
has
many fields that need data updated your solution though it will work is
not
efficient.

Let me state the problem again. We have lets say 5 (though the number is
much larger) different contracts that require the same piece of data
placed
on each of them. This data may consist of a name, address, date, number
of
stores and other information. The information will be the same for each
contract. We would like to use mailmerge or some thing like mailmerge to
perform this task. Some way that will allow us to automate the process
and
be able to run it once when we need to update a contracts. The documents
(contracts) will be in a word format.

Thanks