Link to external tables

<< Click to Display Table of Contents >>

Navigation:  Program Sections > Recipients >

Link to external tables

 

This functions allows you to create links to already existing databases. If information in this databases is changed or adjusted, the recipient lists in SmartSerialMail are automatically updated.

The following example illustrates the use of this function with the help of an already existing Access database.

 

1. Navigate to 'recipientsRecipients'.  and choose the function "New Link to Table" from the toolbar.

 

2. Enter a name for the link.

 

3. Choose, to which list type the imported table corresponds. Then click "Create...".

 

4. In the new window, choose the type of the database from where the table is to be imported.

 

5. Choose "Connection" from the top menu in this window.

 

6. In the field "Use data source name", enter the path to the database, where the table is included. If the source is a file path, also provide the ending of the file. Afterwards, enter the login information to use for the authentication in this database. Click OK.

 

7. Click "Open connection".

 

8. Then specify in the lines beneath, which columns in the imported table correspond to which columns in the recipient list in SmartSerialMail. All of this information is required.

 

9. Click OK. The information is now imported to SmartSerialMail from the chosen table of the extern database.

 

10. At any time you are able to edit the created link, if, for example, the storage location of the database is changed. For that purpose, choose the link from the recipient list and click "Edit Table Options" in the toolbox at the top.