Combining records from multiple tables

[Anthony]

Hello people,
I have a database with multiple tables for different
contact types that we use to run mail. I'm trying to
create one sets of records from those tables so the mail
can be ran simultaneously from the same mail merge. If
you have any suggestions I'd love to hear them.
Your help is appreciated,
anthony

 

[Andrew Smith]

If the tables in question all have similar fields, and only differ in that
they are for different contact types, then the best solution would be to
combine all the tables into one with an extra field to denote contact type.

If this is impractical then you can use union queries to do what you want -
you can't use the design grid for this, you need to edit them using SQL.
There is an example in the Northwind database, and you can look for "union
query" in the help system.