SQL Based Mailing Lists

FTGate allows administrators to create a database from an external database of addresses held in an SQL database.

To use an external SQL list you need to configure a DSN connection and an SQL statement that will retrieve the addresses for the message. The DSN MUST be a system DSN.

The SQL query results must contain the columns ‘Name’ and ‘Address’. Thus if the database does not contain these columns the SQL statement should create them in the returned data set.

For example:

dsn: dsn=mydatabase;uid=user;pwd=password

sql: SELECT DISTINCT EmailAddress AS address, ContactName AS name FROM CustomerDetails

See: Members