Black Lists Properties

The Black list is a data source view of receivers you want excluded from the mailing. The data source can be any database you are able to acquire using eMill's data source wizard. The addresses of the Black List are matched against those of the receivers list, which usually comes from another data source connection.

From the Project/Properties menu, select the Black Lists tab:

Check the box located on the left of a list to enable it, uncheck the box to disable it.
Click on the Add button to add a new list.
Select a list and click on the Edit button to open the black lists properties.
Select a list and click on the Duplicate button to create a new list from the selected one.
Select a list and click on the Rename button to edit the list name.
Select a list and click on the Remove button to delete the selected list. Black lists are optional.
Click on Move up and Move down to change the black lists order.

Black lists properties:

Enabled: Specifies if the list must be used to exclude email addresses or fax numbers when rendering messages.
List name: it aims at identifying a black list. Each list must have a single name.
Filtering: it lets you filter your records by specifying search criteria on your records.

- Select "Match all of the following" if you want to display the records matching all the criteria.

- Select "Match any of the following" if you want to display the records matching one of the criteria.

Change Data Source: calls the Data Source Connection Wizard which will allow you to change your black list data source.

Field Binding: Bind the Email value with the data source field containing the email address and/or bind the Fax value with the data source field containing the Fax number. When a receiver email address or fax number is included in an enabled black list, his email address or fax number will be excluded when rendering messages.

ADO connection string: advanced parameter used to set the link between a database and a receivers list. Click on Properties to create the ADO connection string through the Data Link Properties box. By default, this parameter is automatically completed by the Database Connection Wizard.
SQL query that returns excluded receivers: After successfully linking to the data source, eMill displays all possible queries to access data records inside the tables.
Export the black list when publishing: When publishing to a remote eMill server, the data source may not be accessible or available, or the local database may be too large or complex to upload to a remote server. Enabling this option, the data source will be exported to a temporary database containing only necessary records.