Add/Modify a list
Please enter the list name
Enter a name for the new list. A list name has to be single.
Please select the data source type...
From this step, the wizard will changed according to the selected datasource. Please find below the last steps for creating your receivers list for each data source.
eMill Shared List : Choose this option if yo want to use an existing eMill Shared List. The next step is to select the list name. You won't have to further select a table or a query since this settings are already configured on the eMill server for each shared list.
Excel / Access or Text files: When selecting these data sources, the next step is to select the file. You have the possiblity to choose it among your project file or upload it from your disk.
ADO Connection String: Choose this option if you are an advanced user or if you want to link to SQL Server, Oracle or MySQL databases. Once you have selected "ADO Connection String", you will be prompted to enter the connection string. If you want the application to create it for you, a list of the different connections available is displayed below the text area. You will have to choose the database, the connection string and enter the appropriate parameters. Do not forget to click on OK before going to the next step
XML DataSource: The XML connector mainly aims at retrieving email addresses from eCommerce Shops like osCommerce or Oxid. Indeed, using this option, you can only connect to XML files using the ADO or the ADO.NET XML Format
eMill OptIn Service subscribers list: Click here to find out more about the connection to an eMill OptIn Service account.
pixi* system customers list: Click here to find out more about the connection to a pixi* system.
Import from unstructured text files: This option is useful to quickly send a message to a list of distribution not saved to a database. You do not need to open the file or to have the application installed. The platform scans and recognizes email addresses from the data stream. Once you have selected this option, you can either select a file on your disk or copy and paste your email addresses in a text box.
I don't have a database create one for me: The application will create a specific database file (database.mdb) inside the project tree and will automatically link the project to it. This database will include 4 fields: ContactID, Email, FirstName, LastName, Fax and Mobile. You can then edit fields and records from the application or from Microsoft Access.
Please select the table or query...
On the left part, select a database table/query to visualize its fields on the right part. Highlight the fields you need for your project by clicking on them holding down the CTRL key for multiple selections. Selecting * will generate the query that acquires all table fields. According to the communication channel you want to use (email, SMS and/or fax), it is mandatory to select a field with email adresses and/or fax and phone numbers. Note that the SQL Query used to retrieve data from the database is automatically generated at the bottom of the page. If you are an advanced user, you can also edit it manually.
Please select the channels...
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.
Please associate the following fields
If necessary, make the field associations for information used inside the message headers. Clicking on the scroll down lists present you with all fields you have acquired. According to the communication channel you want to use (email, SMS and/or fax), it is mandatory to associate the email, the SMS and/or the fax field with their database equivalent.
Import receivers...
The import receivers wizard consists in linking the columns of the list where the receivers to import are located to the existing list of the project.
Example: In the list to import, email addresses are located under the 'E-mail Address' column. In the existing project list, email addresses are located under the 'Email' column. In order to import email addresses from the 'E-mail Address' to the 'E-mail' column, you must link these two columns.