Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2006

Tip: Looking for answers? Try searching our database.

Word Mail Merge with Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Victor Lazlo - 26 Apr 2006 00:31 GMT
How is it possible to merge multiple documents with a single source/ms ACCESS
Peter Jamieson - 26 Apr 2006 01:19 GMT
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
> How is it possible to merge multiple documents with a single source/ms
> ACCESS
Victor Lazlo - 26 Apr 2006 18:29 GMT
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.

> 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?
[quoted text clipped - 8 lines]
> > How is it possible to merge multiple documents with a single source/ms
> > ACCESS
Peter Jamieson - 26 Apr 2006 18:42 GMT
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
> 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.
[quoted text clipped - 22 lines]
>> > How is it possible to merge multiple documents with a single source/ms
>> > ACCESS
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.