A Mailing list is essentially a list of Recipients .It Can from either a regular plain text file or (with the DynamicMailer Enterprise Edition) a database such as Access, Oracle, or Sybase.

Simple mailing lists

Simple text file, where each line contains one e-mail address, Click button to Load list of addresses from file.

Mailing List in a File

To create a mailing list file just click the Edit menu, and then click "New Email List..." .The first and most important thing you should do then is give the Mailing List a name. This name must be unique .The Second , you should do then is give the Mailing List field name. The Third ,You should select a filed for Email Column (DynamicMailer will not send email if the Email Column does not contain a standard Internet address like user@domain.com).

  Then you can selected the data File that you want to import Mailing List for importing it.The data File should be on a single line. Each line should contain one or more fields separated by delimiters (use tab, comma, or space). By default, the first line of your file is assumed to be the names of the fields (you can turn this off in Setting). For example, your mailing list might look like:

Month Day Year Company Product  OS   Title  First  Last   Email
May   5   1998  IBM    display  WinNT  Mr.  James  Jones test1@sohosend.com
June  8   1999  Apple  CD ROM   MacOS  Ms.  Linda  Blake test2@sohosend.com
July  17  2000  HP     modem    Win95  Dr.  Henry  Flynn test3@sohosend.com

NOTE: in this example you would use tabs for delimiters so that spaces in phrases like "CD ROM" are preserved, or you might also want spaces in your column heading names.

If you use a spreadsheet, save your mailing list as tab-delimited text (e.g. in Microsoft Excel, use "Save As" and in the "Save as type" select "Text (Tab delimited) (*.txt)".
If you use a word processor or text editor, make sure you save as a .txt file.
If you use a personal database such as Microsoft Works, Access, etc. you can generally "Export" your database as tab-delimited text file ( .txt file).
If your want to use your Address Book from your regular email program, generally these programs let you "Export" your Address Book to a plain text tab-delimited file.  For specific instructions on Microsoft Outlook and Netscape Messenger, see Frequently Asked Questions under "Mailing Lists".

The DynamicMailer Personal Edition supports mailing lists of up to 500 names.  The DynamicMailer Business and Enterprise Editions remove this limit (for example, we routinely use lists over 100,000 names).

Note :Do not build huge lists of addresses because they will work slowly! It is recommended to create lists about 100,000 recipients per each, not more! 

Mailing List in a Database (requires DynamicMailer Enterprise Edition)

To use a mailing list from a database, you make a standard SQL-style query against any local or remote database for which you have a JDBC or ODBC driver. 

To read your mailing list from a database, In Setting you will need the following four pieces of information.
    1) your database driver name 
    2) your data source name ("DSN") or URL 
    3) your database login name 
    4) your corresponding password

These values are entered in accordance with values you set up in the Windows "ODBC" Control Panel (on Win 95: "32bit ODBC", on Win98 "ODBC Data Sources (32bit)", on Win NT "ODBC Data Sources") to tell Windows about your database.
When you select Database Mailing list DynamicMailer will read your database using these values.  By the nature of the underlying system software, You might have the DSN wrong, the password wrong, the select command wrong, or your network connection may be down, and you'll get the error message inside DynamicMailer in all cases.  So, if you aren't sure of your correct values, it is a better idea to verify them using the database reader provided by your database vendor rather than do a lot of trial-and-error inside DynamicMailer.  Once they are correct, the same values should work inside DynamicMailer.
To create a mailing list in database just click the Edit menu, and then click "New DataBase Email List" . enter the mailing list name into the "Group name", and enter SQL query ("SELECT") command into the command , Click "Execute" button, then, if the select command don¡¯t wrong ,select mail column" (DynamicMailer will not send email if the Email Column does not contain a standard Internet address likeuser@domain.com).

Example 1:  Here's how to use the sample database ("Northwind")  supplied with Microsoft Access 97.  These instructions assume you have already installed the Northwind sample database and your Microsoft Access Driver on your system using Microsoft Access (or Microsoft Office) installation disk.  To verify this, be sure you can open Northwind inside Microsoft Access.  If you didn't install Northwind when you first installed Access or Office, you can use  Microsoft Access or Office installation disk to add it now.

Next, you need to make a "User DSN" for Northwind. To do this, go into your Windows Control Panels and open your system's ODBC control panel.  Look at the "User DSN" list.   Depending on your release of Microsoft Windows and Microsoft Office, the Northwind database (along with other Access databases) may already appear in the list and be ready for use.  If you don't see "Northwind" in the list, click on Add, then Microsoft Access Driver, then Finish, then enter the DSN name "Northwind", then hit Select and locate Northwind.mdb on your system, then say OK.  Now Northwind should appear in your User DSN list.

Now run DynamicMailer and use the following settings for the Database driver, Data Source Name/URL, Username, Password in the Setting dialog:

sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:Northwind
(user name not needed)
(password not needed)

Then ,click the Edit menu, and then click "New DataBase Email List" . Just enter the mailing list name into the "Group name", and enter SQL query command into the “Command* , Click "Execute" button, then, if the select command don't wrong ,select * email column"
You do not need to be running Access when you run DynamicMailer, as DynamicMailer is able to read your database directly without needing to run Access. Once you get Northwind to work, other Access databases should work in the similar manner.  Of course, you can always do an "Export" under Access (and most other databases) to produce a tab-delimited text file and read that into DynamicMailer.

Example 2: To use the sample database supplied with Oracle 7.0 database, use the following settings in DynamicMailer:

oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@dlsun511:1721:dbms733
scott
tiger

Then ,click the Edit menu, and then click "New DataBase Email List" . Just enter the mailing list name into the "Group name", and enter SQL query command (select * from customer ) into the command , Click "Execute" button, then, if the select command don't wrong ,select mail column"

DynamicMailer by Sohoany Inc.