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

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/Compou...poundMerge.htm

Peter Jamieson
"J. Webb" J. wrote in message
...
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

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.

"Peter Jamieson" wrote:

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/Compou...poundMerge.htm

Peter Jamieson
"J. Webb" J. wrote in message
...
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