Need design idea help

[Diggar]

I have a mailing list of 3000 names address etc that I need to setup in a way to be able to print lables.

What I am wondering is the best way to set it up so that I can choose addresses by county, which is a separate field.

Also I want to be able to mark the records that I have already sent out so I don't resend those but can view them as I am choosing new records.

Is this too much work in Access? Is there a mailing program that is easier to use?

Thanks

 

[jhall01]

This is an ugly way to do it but make a master table for each mailing. and As you add new ones make new tables. This is very ugly and very innefficient but allows you to create tracking with minimal Access knowledge.

another way is to create a master table with an additional flag column called something like mailing_sequence. Here everytime you mail something you increment the sequence with an update query. as you add new addresses you will set their sequence = 0. This way you can run queries on where mailing_sequence = mailing #.

Once you have created the queryies for each mailing number you can run a label report using those queries.

If you are more advanced at access you may look at creating a master table with a master_seq and other print dates and create a macro that will run the queries based upon a prompt for a date or sequence number, then create the labels and update the print date in the table or sequence # all in one push of a button.

These are just a few ideas depending on your level of expertise