<< Click to Display Table of Contents >> Navigation:  Basics > Recipient Lists and Sending > Recipient Lists and Sending Examples > Example 3: "How do I use a table from an external database?"

Prerequisites:

You want to connect a table in your database directly to SmartSerialMail.

 

Example:

You already have an Microsoft Access database containing the email addresses of your customers. Now you want to use these addresses in SmartSerialMail without having to import the data for each sending operation.

 

Implementation:

•Click on "New Link to Table" in "Recipients" menu "Home". You will be prompted to enter a name for the new list.

•Select the type of List in the "List Properties" dialog. You can use the list as an recipient list or as a blacklist.

•Enter a name for the external table link.

•The "List Properties" Dialog Window appears:

oPlease select the "Build..." Button to specify the database connection to your Access file.

oWhen you have specified the connection click on "Open Connection".

oNow select the "Table" and assign the necessary columns from your external table.
Please note the conventions: "Primary Key" (needs to be a unique integer value), "Status Column" (needs to be a integer column).
All other columns need to be string values.

oClick "OK".

The list from your external table will now be shown in SmartSerialMail. Editing the list will directly affect your database.

You can edit the properties of the external table connection by clicking  "Edit Table Options" in the "Home" menu.