I want to add a list of about 500 people.

[Mike101]

I need to add a list of newsletter subscribers to the database. I have Access 2003 and I want to be able to run an SQL query to add a list of about 500 people.

[devicode]

The easiest way to add subscribers to the prospect database is by importing the information.

Response Mailer allows you to import prospect data into the software.
You can import the prospect name. email address and other prospect related information in the prospect database. The information will populate the 'Prospect Details' and the 'Custom Fields' data fields.

You can import this information for a tab delimited or comma delimited file.

1. Create a Prospect List
   Use your favourite text editor or spreadsheet program like Excel to create a list of prospect.
   You will need 2 columns to store the information. The first column stores the email address and the second one stores the name.
   For example:
   Name,Email
   Billy Bob,bill@yourdomain.com
   "Paul Brown, jr",paul@yourdomain.com
   Note: You can add more fields if you need.
   
2. Import your Prospects
   Choose option "Prospect Manager" from the Tools menu.
   
3. Select the leads file
   Select the follow-up responder that you want to add these prospects to.
   Select the text file with the list of email addresses.
   
4. Change the Field Mapping to match the order of the fields in the leads file.
   Click the "Start Import" button.
   
5. Verify
   Your newly imported subscriber will be scheduled to receive the first letter for this followup responder.