List Properties
General
Enabled: Specifies if the list must be used or not when rendering messages.
List Name: Identifies a list. Each list must have a unique name.
Connection string
This string is used by ADO to connect to the data source. The string identifies the driver to be used as well as various other settings used by the ADO driver. The connection string can be edited manually or by clicking on 'Data Source' to launch the wizard for modifying the data source.
SQL Query
The SQL Query is used to retrieve the records from the data source. It can be edited manually or by clicking on 'Data Source' to launch the wizard for modifying the data source.
Retrieve all fields from: This drop down list allows you to easily modify the SQL Query. You just need to select one of the data source table/query and it will retrieve all the fields from it.
Shared List
Connects the list to a predefined eMill shared list. The Connection String and SQL Query parameters are predefined on the eMill server and are not available when selecting a shared list.
Channels (only for receivers list)
It lets you decide which communication channel you want to use in this project. If multiple channels are enabled, the message will use the first usable channel based on the position of the channel in the list.
Examples when email and fax are activated:
- If the Email field is existing and the Fax field is empty, the message will be sent to the email address.
- If the Email field is empty and the Fax field is existing, the message will be sent to the Fax number.
- If both Email and Fax fields are existing, the message will be sent to the email address if the email channel is the first in the channels list and to the fax number if the fax channel is the first.
Column Binding
The application requires that you bind fields which are used to address your messages. These fields are then used to create the receivers email, SMS or fax address. For black lists, when a receiver email address or fax/phone number is included in an enabled black list, his email address or fax/phone number will be excluded when rendering messages.
Advanced
Check the "Use global script to access data source" option if you want to use a non-ADO compatible database as a data source. For more information, on how to use Global Script to connect to a non-ADO database, see DataSource Events.
Data Source
Click on this button to launch the wizard for modifying the data source.