Is it possible to mail merge two access tables into one word docum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if anyone knew if you can make one mail merge document based
on two access tables. One table has say client information. The other is the
products assigned to a client. It is a many to many situation with the
product information coming from a seperate table.

If anyone could help that would be great. Thanks :)
 
you should be able to run a mail merge based on a *query* rather than a
table. just link the three tables in a query, pull the fields you need for
the mail merge into the query design grid, add any criteria you need to
return the records you want, and save the query. then proceed with your mail
merge, using the query instead of a table.

hth
 
Create a query that pulls the needed fields from the 2 or 3 tables. Base
your mail merge on this query.
 
Back
Top