Re: Help with merging 1 address to many files
- From: "FL Consultant" <FLConsultant@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Jul 2005 02:22:04 -0700
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
> >
> >
>
>
>
.
- Follow-Ups:
- Re: Help with merging 1 address to many files
- From: Peter Jamieson
- Re: Help with merging 1 address to many files
- From: Doug Robbins
- Re: Help with merging 1 address to many files
- 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
- Help with merging 1 address to many files
- Prev by Date: Re: How to stop source prompt in mail merge from access
- Next by Date: Re: Help with merging 1 address to many files
- 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
|