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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

E3 - 29 Oct 2006 06:07 GMT

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 :)

Reply to this Message

tina - 29 Oct 2006 17:17 GMT

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

> 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 :)

Reply to this Message

Joan Wild - 29 Oct 2006 17:19 GMT

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

Signature

Joan Wild
Microsoft Access MVP

> I was wondering if anyone knew if you can make one mail merge
> document based on two access tables. One table has say client
[quoted text clipped - 3 lines]
>
> If anyone could help that would be great. Thanks :)

Reply to this Message