multi mail merge

[david magee]

can i mail merge data from more than one table? i have
identical tables and want to mail all the contacts in
each without having to merge each table individually.
creating a large table is not an option as the data is
constantly updated. i cannot create a query as the data
is not related. any ideas?

 

[Cheryl Fischer]

Since your tables are identical, have you considered a Union Query? These
are created in the SQL View of the Query Designer and would look like the
following:

SELECT FirstName, LastName, Address, City, State, Zip
FROM Table_1

UNION SELECT FirstName, LastName, Address, City, State, Zip
FROM Table_2

UNION SELECT FirstName, LastName, Address, City, State, Zip
FROM Table_3
ORDER BY LastName, FirstName;