Word Mail Merge with Access

[Victor Lazlo]

How is it possible to merge multiple documents with a single source/ms ACCESS

 

[Peter Jamieson]

Do you mean that you want to produce several completely different letters
(say) depending ont he value of one or more fields in the Access database?
If so, the simplest appraoch is to do one merge for each letter and either
create an Access query to select the records for each merge, or do it using
the filtering facilities within Word.

If you mean something else, could you give an example? It may help if you
can tell us the version of Word and Access.

Peter Jamieson

 

[Victor Lazlo]

We are using MS Word 2002, Access 2002. Using a single query in access we
have a variety of documents whose data source is the same query.
Staff routinely "open" one merge document at a time, perform the merge,
close the document, then open another document also linked to the same query
and repeat the process for each subsequent document. So to be more efficient
we would like to "open" a number of documents that are all linked to the same
query.

 

[Peter Jamieson]

OK, but some clarificaiton still needed. Are you having problems because a
single user (or perhaps multiple users) cannot open mailmerge documents
connected to the same query at the same time, or is it that you want to
select a query and use that as the basis for a succession of merges (e.g.
you have merge main documents a, b, c, and one day you want to connect them
all to query y and the next day you want to connect them to query z) ?

Peter Jamieson