Product manual

GFI MailEssentials 10 Email Management | 210
Option Description
Microsoft Access
with Existing
Option
In the File field specify the path to your existing Microsoft Access database that contains the
newsletter/discussion subscribers. From the Table drop down list select the table where the
subscribers list is stored.
Microsoft
SQLServer with
Automatic Option
Specify SQL server name, logon credentials and database used to store newsletter/discussion
subscribers list.
Microsoft SQLwith
Existing Option
Specify SQL server name, logon credentials and select the database and table where subscribers
list is stored.
6. For all database types with the Automatic option, click Finish button to end the wizard, or click
Next to continue setup.
7. If you are configuring an existing Microsoft SQLServer, set up the connection to the Microsoft
SQLServer. If configuring a Microsoft Access Database, configure the path to a file and select a
table within the Microsoft Access Database to use.
8. Select a variable from the Variables list and the corresponding Database Field option and click
Map Field button to Map the required fields with the custom fields found in the database. Click
Finish to finalize your configuration. The fields to map are:
Variable Description
[FirstName_
To]
Map to a string field containing the first name of a subscriber.
[LastName_
To]
Map to a string field containing the last name of a subscriber.
[Company] Map to a string field containing the company name of a subscriber.
[Email_To] Map to a string field containing the email address of a subscriber.
[Unsubscribe] Map to an integer (or Boolean) value field which is used to define whether the user is subscribed to the
list or not.
9. Customize your newly created list. For more information, refer to Configuring advanced
newsletter/discussion list properties (page 211).
10.3.2 Using Newsletters/Discussions
After creating a newsletter/discussion list, users must subscribe to be part of the list.
Action Description
Subscribing to list Ask users to send an email to
<newslettername>[e-mail]
Completing
subscription process
On receiving the request, list server sends a confirmation email back. Users must confirm their
subscription via a reply email to be added as a subscriber.
NOTE
The confirmation email is a requirement and cannot be turned off.
Sending a
newsletter/discussion
post
Members with permissions to send email to the list are required to send the email to the
newsletter list mailing address:
<newslettername>@yourdomain.com
Unsubscribing from
list
To unsubscribe from the list, users must send an email to:
<newslettername>[e-mail]