mail merge

[awake2424]

Is there a way in Access 2003 that a document can have data fron 2 tables in it? So, I have two tables in access that I want to do a mail merge from table 1 and populate half a word document. Then do another mail merge from table 2 and populate the other half of word. I hope I am making sense. I am not sure what to do. Thanks.

 

[WayPay]

If the two tables contain similar fields, you
1. probably have a normalization problem , but
2. could maybe use a UNION query to combine the results from the two tables, then do the mail merge in 1 go.

SELECT contact1.contact_name, contact1.contact_address
FROM contact1
UNION ALL
SELECT contact2.contact_name, contact2.contact_address
FROM contact2

I'm not sure you can do a mail merge and stop halfway through.