Access Database for Multi-Category Mailing Lists

[ChaliceHolder]

I want to make several mailing lists into one. Currently some are in WordPerfect, some in Access. All lists are separate, so one name and address can be listed multiple times. Would like to create a database in Access: one record with multiple categories, say 10 each. Goal: to have a database in which an address/person is input one time only and every category that each user may assign will still pull that record on request. Example: ChaliceHolder can be assigned the following categories: Curator, Museum, Gallery. If I want to send to a mailing to all the museums and galleries, then ChaliceHolder would come up.

Some people on the WordPerfect list are listed twice: a home address and a business address. Would like to create one record, include both addresses and have the ability to select home, business or both in each record.

What is the best way to set this up? Thanks.

 

[dawnd3]

You need to import the data into Access and do a series of queries to append the data to the correct tables. You will need to find some way to attach a unique ID to the contacts so that duplicates will not occur and so that you match up the correct data in the other fields to the contact. I would say concatinate first and last name just for the purposes of importing. This is a big job and not something easily explained in an answer here. The very first step is to set up your tables and relationships. As far as importing the data I would have to see the format and structure it is in now to be more specific with advice.

Dawn

http://www.calliopeconsulting.net