Sep 18, 2020 
Support Center » Knowledgebase » VisNetic MailServer » Personalized Mailing List
 Personalized Mailing List
Solution
Currently you have two options for adding variables to a personalized mailing list, standard file or ODBC. Standard file is implemented from the members tab, the parameters are entered in the members parameters field, each variable is on a line by itself. Example,
 
name=John Smith
pricequote=$200
discount=10%
total=$180
 
After you add the variables to a member and save it to file it will appear in the List file in a specific format, please review it closely if you plan on manually editing this file, any deviation from this format will cause the variables to fail.
 
Each member can have unique variable entries.
 
SQL statements can be used to select the mail recipients and other fields from the DB such as personalized mailing list. The statements field can contain multiple lines of SQL statements but is limited in size.
 
If you use the Remove dead email addresses option you have to specify the SQL DELETE statement here using the following format:
 
DELETE * FROM WHERE = %s
 
Replace 'YourTable' and 'YourEmailField' with the proper values to reflect your database table structures. The %s character is a system variable that will be used as a substitute of the email address to delete from the table.
 
If you require a long SQL string you can type in the full filename of a text file containing the long SQL string. The mail server will automatically recognize if the text in this field is an SQL statement or a filename.
 
Summary - Create a new database or table in a database that contains a column for your mailing list email addresses and a column for rights (personalization columns are optional). The email address much be first followed by the rights. Create an ODBC connection (Windows Control Panel - Administrators Tools) to the database or use an existing ODBC connection that connects to your mailing list table. Create a mailing list and set it to Members From ODBC in Source option. Set ODBC settings and the SQL query to get a list of addresses, rights and variables.
 
The SQL query has to be designed in a way that it returns the email addresses at the first position and rights at the second. All others are used as variables. Example:
 
SELECT Email, Rights, Name, pricequote, discount, total FROM Employee
 
To return all data,
 
SELECT * FROM Employee
 
Use the Test button to verify your SQL statements. The test ONLY returns the email addresses and rights, example,
 
 
Please refer to the SQL help file for statement help.
 
Example message,
 
---------------------
Hi {{name}},
 
Retail price: {{pricequote}}
Sales discount: {{discount}}
Total: {{total}}
 
Thanks!
 
Sales Team
---------------------
 
This message will be sent to the mailing list member as,
 
---------------------
Hi John Smith,
 
Retail price: $200
Sales discount: 10%
Total: $180
 
Thanks!
 
Sales Team
---------------------


Article Details
Article ID: 552
Created On: Sep 21, 2006 09:20 AM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | News | Downloads
Language: