How do I use two data sources in same document for mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Webb - 20 Apr 2006 15:34 GMT

Is it possible to link two access databases to a single Word document for the
mail merge function? The way the data is set up, the 1st access db pulls the
project leads. The 2nd access db would be a query on the 1st db results and
list all the programmers assigned to each project. I only want the e-mail to
go to the project lead and not the programmer.

Also - if there is an easier way to do this, I would appreciate any
suggestions. This process needs to be as repeatable, efficient and simple as
possible.

Thank you! Jennifer

Reply to this Message

Peter Jamieson - 20 Apr 2006 15:58 GMT

Word isn't really designed to do this, but with some limitations you can do
it by setting up the 1st access table/query as the mail merge data source,
and using a DATABASE field to get the list of programmers. You have to edit
the SQL in the DATABASE so that it has a WHERE clause that restricts the
records returnd to the current project, e.g. if the project lead has a
column called ProjectID which is used as a foreigh key in the programmer
list, you might have a WHERE claues such as

WHERE `ProjectID` = '{ MERGEFIELD ProjectID }'

There's an example at

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Peter Jamieson

> Is it possible to link two access databases to a single Word document for
> the
[quoted text clipped - 12 lines]
>
> Thank you! Jennifer

Reply to this Message

J. Webb - 20 Apr 2006 18:23 GMT

Hi Peter - Thank you for your reply. We will try this method and if we have
any additional problems, I'll send another post tomorrow. Thank you again!
Jennifer.

> Word isn't really designed to do this, but with some limitations you can do
> it by setting up the 1st access table/query as the mail merge data source,
[quoted text clipped - 27 lines]
> >
> > Thank you! Jennifer

Reply to this Message