Recipient Lists

One way to organize your address lists is to use Recipient Lists in SerialMailer. This window displays all your recipient lists, including those from the Contacts application (if they are not visible, make sure to give SerialMailer permission to access your contacts).

../_images/database_manager.png

Data Sources

You can use Recipient Lists to access lists from different sources:

Contacts

Here you find the contacts stored in the Contacts Application. They cannot be edited in SerialMailer.

My Lists

This is SerialMailer’s internal database. Here you can create your own recipient lists with custom fields. These lists are only accessible within SerialMailer.

Online Lists

SerialMailer can download address lists from remote sources. Note that any edits to addresses in these lists are temporary and will be overwritten when a new version is downloaded from your web server.

To rename a list, double-click its name. To add a new list, press the + button and choose either New Local List (to store it in My Lists) or Add Online List.

Use the Options menu below the recipient list to change the field/column names.

Online Lists

Online address lists allow you to download a list of addresses from a web server and automatically import it into SerialMailer. This can either be a static file or it can be generated dynamically using a script running on the server (e.g., to access a MySQL database).

To secure the list, you can make use of HTTP authentication. SerialMailer will then request the password from you when needed.

../_images/database_manager_remote_create.png

To update an online list, select it and press the Download button in the lower right of the window.

The format of the list should be that of a CSV (comma-separated value) file. A basic example could look like this:

EMail, Name
peter@example.com, Peter
jessica@example.net, Jessica

Note that the first line is interpreted as the field names.

Import / Export

SerialMailer can import and export various files as recipient lists, including:

CSV/Text

A basic text format that can be exported by most spreadsheet applications

Excel (xlsx)

Excel tables. SerialMailer only supports the newer xlsx format, which was introduced with Excel 2007.

SerialMailer file

Imports the recipient list of a SerialMailer Message document.

The Import/Export commands are available from the File menu.