Re: Help with merging 1 address to many files
- From: "Doug Robbins" <dkr@xxxxxxxxxxxxxx>
- Date: Thu, 21 Jul 2005 13:04:09 +0200
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
"FL Consultant" <FLConsultant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B6C9B54-B608-46FE-BE19-CF5C5850A18D@xxxxxxxxxxxxxxxx
> 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
> --
> FL Consultant
>
>
> "Doug Robbins" wrote:
>
>> 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
>> "Doug Robbins" <dkr@xxxxxxxxxxxxxx> wrote in message
>> news:uyxA8hOjFHA.2920@xxxxxxxxxxxxxxxxxxxxxxx
>> > 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" <FLConsultant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> > message
>> > news:A06AB413-BB7B-4736-AF5B-B0A994E3B0BA@xxxxxxxxxxxxxxxx
>> >> 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
>> >> --
>> >> FL Consultant
>> >
>> >
>>
>>
>>
.
- References:
- Help with merging 1 address to many files
- From: FL Consultant
- Re: Help with merging 1 address to many files
- From: Doug Robbins
- Re: Help with merging 1 address to many files
- From: Doug Robbins
- Re: Help with merging 1 address to many files
- From: FL Consultant
- Help with merging 1 address to many files
- Prev by Date: Re: Help with merging 1 address to many files
- Next by Date: browse in mail merge
- Previous by thread: Re: Help with merging 1 address to many files
- Next by thread: Re: Help with merging 1 address to many files
- Index(es):
Relevant Pages
|
