Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Victor Lazlo
 
Posts: n/a
Default Word Mail Merge with Access

How is it possible to merge multiple documents with a single source/ms ACCESS
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Word Mail Merge with Access

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" wrote in message
...
How is it possible to merge multiple documents with a single source/ms
ACCESS



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Victor Lazlo
 
Posts: n/a
Default Word Mail Merge with Access

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

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" wrote in message
...
How is it possible to merge multiple documents with a single source/ms
ACCESS




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Word Mail Merge with Access

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
"Victor Lazlo" wrote in message
...
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" wrote:

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" wrote in message
...
How is it possible to merge multiple documents with a single source/ms
ACCESS






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Using Word Mail Merge feature for custom templates S.Sanghani Mailmerge 3 January 11th 06 10:22 AM
why word 2000 mail merge opens multiple instances of access table. Johnny C. Mailmerge 0 February 3rd 05 05:11 PM
Web-Site-based Word Mail Merge & Access DB Alex Maghen Mailmerge 3 January 17th 05 09:52 PM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 02:29 PM


All times are GMT +1. The time now is 08:01 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"