Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2005

Tip: Looking for answers? Try searching our database.

Help with merging 1 address to many files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FL Consultant - 20 Jul 2005 01:20 GMT
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
Signature

FL Consultant

Doug Robbins - 20 Jul 2005 06:04 GMT
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.

Signature

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

> We use mailmerge to create contract files using one file, the contract,
> with
[quoted text clipped - 8 lines]
>
> Thank you
FL Consultant - 20 Jul 2005 12:53 GMT
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
Signature

FL Consultant

> Not mailmerge, but something like the article "Find & ReplaceAll on a batch
> of documents in the same folder" at:
[quoted text clipped - 15 lines]
> >
> > Thank you
Doug Robbins - 20 Jul 2005 18:48 GMT
Run it as many times as necessary or or modify it so that it handles
multiple replacements.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

> Not mailmerge, but something like the article "Find & ReplaceAll on a
> batch of documents in the same folder" at:
[quoted text clipped - 16 lines]
>>
>> Thank you
FL Consultant - 21 Jul 2005 10:22 GMT
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  
Signature

FL Consultant

> Run it as many times as necessary or or modify it so that it handles
> multiple replacements.
[quoted text clipped - 19 lines]
> >>
> >> Thank you
Doug Robbins - 21 Jul 2005 12:04 GMT
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.

Signature

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
[quoted text clipped - 44 lines]
>> >>
>> >> Thank you
Peter Jamieson - 23 Jul 2005 12:25 GMT
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
[quoted text clipped - 44 lines]
>> >>
>> >> Thank you
Anne Troy - 22 Jul 2005 15:42 GMT
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

> We use mailmerge to create contract files using one file, the contract, with
> many addresses.
[quoted text clipped - 6 lines]
>
> Thank you
FL Consultant - 23 Jul 2005 11:28 GMT
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.
Signature

FL Consultant

> You might want to try this:
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=381
[quoted text clipped - 17 lines]
> >
> > Thank you
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.