Opt-Out email addresses

[Christine]

I have a Db currently in Excel with approx. 16000 email addresses/members. I have an Opt-Out list of about 250 that need to be removed from the Db. I will get an updated Opt-Out list regularly and need to remove those names from the Excel Db. In addition we will have an Excel spreadsheet listing which members have attended which seminars. I'd like to keep track of all this information in the same Db. Is Access the right tool to do this in and if so, does anyone know of a template available for it.

Thanks for any help you can give me.

 

[John Vinson]

I have a Db currently in Excel with approx. 16000 email addresses/members. I have an Opt-Out list of about 250 that need to be removed from the Db. I will get an updated Opt-Out list regularly and need to remove those names from the Excel Db. In addition we will have an Excel spreadsheet listing which members have attended which seminars. I'd like to keep track of all this information in the same Db. Is Access the right tool to do this in and if so, does anyone know of a template available for it.

Thanks for any help you can give me.

Excel can do this very handily. You'ld need four or more tables - one
for Members, one for opt-outs, one for seminars, and one for seminar
attandance. It would be very easy to create a Delete query to
permanently remove members of the opt-out list from the address table,
or one could create a query to keep those members in the table (for
historical reasons perhaps) and create a list of all the members who
are not on the opt-out list.