Mail merge from multiple tables

[Jerry]

We are using Access 2003. We want to do a mail merge using multiple tables.
Is this possible ? Thanks

 

[Jeff Boyce]

Jerry

Are you saying that you have multiple tables holding the same (kind of)
information (i.e., name, address)? Is there a business reason why they are
separate? Have you looked into a UNION query as a way of gathering what you
need from each?

Are the tables related to each other (you could use a query to join them)?

Good luck

Jeff Boyce
<Access MVP>

 

[LReber]

Hi Jerry
Once a year we do a major mail merge based on at least 4 tables ( I lose
track.) I got help from this site last year, then refiened my queries and got
it right finally this year. Regarding Jeff's comment, we DO need to keep the
tables separate, though it does make the query structure more complex. We have
tblContacts [name, address, etc.]
tblShowRegistrations [Regis date, amt paid, PK, FK]
tblFleaMarketRegistrations [Regis Date, Amt Paid, Vendor Type, PK, FK]
tblContactStatus [Status types, PK, FK]
qrySelectZips
qryDeceasedOrStaff
qryShowRegistrations
qryFleaRegistrations

I went with four queries because I couldn't figure out how to select only
specific records in one pass; not sure if I'm ignorant or if it's not
possible. Anyhow:
qrySelectZips pulls name and address info from tblContacts where zip code
criteria XYZ are met.
qryDeceasedOrStaff removes contacts with those statuses from results of
"Zips"
qryFleaRegis & ShowRegis prompt for registration dates and eliminates any
contacts who have already registered. That saves us from mailing a form to
anybody who has already paid up.

This one is so complex that I documented it for anyone who follow me in this
job AND for me to refer to in case I do something silly, like change a field
name between now and next year.

Good luck with your project; let me know if you need more information. - Lisa