Re: Help with merging 1 address to many files

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

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


.

Relevant Pages

  • Re: How to Merge data from an ascii file into a Word Doc
    ... The approach Graham originally suggested uses Mailmerge and Mailmerge fields. ... When your document is connected to a mailmerge data source and you re-open it, you get that SQL message. ... The approach I suggested and which Graham has added to does not rely on mailmerge, uses DOCVARIABLE fields rather than mailmerge fields, and does not result in the SQL message. ... Dim iCount As Integer ...
    (microsoft.public.word.docmanagement)
  • Re: insert mailmergefields in word 2007
    ... One possible reason why MailMerge changed quite radically between the 2000 and 2002 versions was because lots of ordinary users didn't really understand mailmerge or how to use it - for them, having the ability to attach a header probably looks like a complication rather than a desirable feature. ... From a programming/software design point of view, there are other awkward questions, e.g. what to do if the header fields don't match the fields in a data source attached later in the process. ... Support for header files has been gradually removed since Word 2000, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail merge in Word (Datasource: Access)
    ... created that contains a "sub-doc" for each student and the original data ... once I have> set up these "sub-doc." ... >>>>I am not sure what you mean by the mailmerge document. ... > If it is a document>>that was previously created by executing the mailmerge,> then it will not be>>updated as there is no link between that document and> the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge VBA problem in Word/Access 2003
    ... Note The MailMerge object is available regardless of whether the specified ... with an attached data source. ... > I'm not sure what your point is because this is actual VBA ... > code from an Access 2000 function which DOES execute a ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Automate opening a merge with Mailmerge Recipients open
    ... To disconnect the data source, change the type of document from a mailmerge document to a normal Word document and then change it back to the desired type of mail merge main document. ... As far as the "field mapping" is concerned, if by that it can be implied that you are not using the actual names of the fields from the data source, then it would be far better if you did use the data source field names directly as then no mapping would be required. ... datasource linked to the query, only now the query has been changed. ...
    (microsoft.public.word.mailmerge.fields)