how to place fields from 2 different databases into word mailmerge document?

[Guest]

Help!
I have created database A and Database B.
Database B contains addresses for individuals in database
A data.
If I would like to combine these 2 databases on a word
mail merge document. How do I do this in access 94?
I would also like to print envelopes using certain fields
from each of these databases. Is this possible?

 

[tom]

I assume the two tables have a common Key field? Unless you have good
reasons to split this data you should consider using only 1 backend
database, especially when the data you mention should have referential
integrity. Bring the two tables together and create a query that is used by
Word... Either link one of the tables to the other, or create a 'front end'
database that has both tables linked to it. Then create the query and use
Word's mail merge facility specifying the query as its data source. You can
also print envelopes in Word using the same principle.

HTH.

Tom.