We send out a newsletter monthly to over 10000 receipients from a wide range of business sectors. We use an Access database to manage the list and GFI Mail Essentials to do the mailing.
We would like to target our audience and split the database into business sectors to send out specific emails to specific people.
At the moment, all subscribers are in one table, however i have added a an additional column with a number to associate with a particular industry.

I need to separate or copy off each industry into it's own table or database so that the mailing software can do it's thing.

Ideally, i need help to create 9 additional tables that follow the main table, filtered by an id number.



I can't get my head around how to do this, and many access tutorials dont provide any assistance. I thought this would be a simple project, but it's doing my head in.

Can anyone help?