Hi:
You can certainly do this in Access.
Depending on the structure and consistancy of your multiple databases
you may have to do some tedious work by hand.

This is the outline:
Assume 3 groups (a,b,c).
Create a new Access DB
Import the 3 tables for the individual dbs.
Name them AMembers,BMembers,CMembers or something like that.
Create a Master table that contains the name and address and any other
fields from the original tables that you want.
In the master table add 3 fields of type boolean (true/false)
Name them AMem,BMem,CMem. Default them to false

Write an insert query and insert alll the AMembers into Master. Write
a query and run it to Update AMem to true.

Append BMembers to Master using the same method as above but setting
BMem to true.

Do the same for CMembers.

Your Master will now contain duplicates.
Sort it by Last name and manually look through it (There are other
ways to do this, but they get trickey. If you have multiple thousands
of records and you get this far, contact me and I'll do the queries to
find the dups for you.) When you se a duplicate record, change the
frst record to reflect a true in the column of the second and then
erase the second.

This is tedious.

Once this is done you set up mailing lists using a query that
references the boolean fields. You can add as many groups as you want
and the method is always the same.

Good luck.

Ira Solomon


On Fri, 04 Aug 2006 11:10:37 GMT, "Stephen" <scicero (AT) si (DOT) rr.com> wrote: