51
structure of this table.
Button "SQL query"
You can create your own SQL query, to perform complex table
queries or to import recipients with special conditions.
If you don't create your own query SuperMailer will ever use the
query SELECT * FROM <table name>.
Allocation to SuperMailer
field
Select (activate the checkbox) on all fields which should be
imported. After that, perform a double click on every fieldname to
define the corresponding SuperMailer field identifier. For example
table field "name" could be imported to SuperMailer field identifier
"name" in your list of recipients. If you start the import, SuperMailer
will transfer all data to this field name.
don't delete existing
recipients list
Activate this setting and SuperMailer will not delete your existing
list, instead it will only append new data.
Hint:
To avoid duplicates use the function "Remove duplicates".
Import to recipients group
Select the recipients group the recipients should be imported.
Button "Import now"
Click on this button to start the import. This button is only active,
if at least one field identifier is assigned to a table field and you
have an active database connection.
Import automatically on
opening project file
Activate this option to let SuperMailer import your recipients on
opening the saved project file automatically.
ODBC driver
Various ODBC driver are already installed on your windows system, for example MS Access
ODBC driver. Many drivers can be downloaded on their manufacturer homepages, other drivers
will be installed automatically if you install a database client or server. A MySQL ODBC driver
can be found on http://www.mysql.com/
.
Example Microsoft Access Database
Create a database called addresses. This database contains a table customers. The table has
following structure:
fieldna
me
data type
ID
auto increment
name
char (50)
firstname
char (50)
email
char (50)
Page 42
