Download Campaign Enterprise Version 11 - Mass email marketing software

Manage Email Campaigns
please call." will appear in the message. In all other cases, the string "sorry, you
make too much money to get the discount." will appear in the message.
"Dear Stephen, yes, you are eligible for a discount."
"Dear Cheryl, small businesses may or may not be eligible, please call."
"Dear Jerry, sorry, you make too much money to get the discount."
Case Statement that Returns a Field from the Database:
{CASE WHEN OrgType=1 THEN "{Field1}" WHEN OrgType=2 THEN "{Field2}"
ELSE THEN "{Field3}" END}
Field1 and Field2 are additional fields stored in your database table. In this case
if the OrgType in any of the records is equal to 1 the value in the table for the
field named Field1 will appear in the message. If the ID is equal to 2 then the
value in the table for the field named Field2 will appear. In all other cases, the
value in Field3 will appear in the message.
"Dear Stephen, the discount is 15%."
"Dear Cheryl, the discount is 10%."
"Dear Jerry, sorry, you still make too much money to get the discount."
Case Statement that Returns a File:
{CASE WHEN OrgType=1 THEN "{FILE:C:\messagefolder\OrgType1textfile.txt}"
WHEN OrgType=2 THEN "{FILE:C:\messagefolder\OrgType2textfile.txt}" ELSE
THEN "{FILE:C:\messagefolder\default.txt}" END}
In this case if the OrgType in any of the records in your database is equal to 1
then message contained in OrgType1textfile.txt will appear in the message. If the
OrgType is 2 the OrgType2textfile.txt will appear. In all other cases, the
OrgType2textfile.txt will appear in the message. Using this method you can
change whole paragraphs on the fly or send entirely different messages to the
people on your list.
It is possible to use a combination of the above methods to dynamically compose
your messages. The statement could return a field for one response, and a file
for another response in whatever combination works best. For example:
{CASE WHEN OrgType=1 THEN "{FILE:C:\messagefolder\ID22textfile.txt}"
WHEN OrgType=2 THEN "{Field2}" ELSE THEN "sorry, you make too much
money to get the discount." END}
Different constraints can also be used in the same Case Statement, for example:
{CASE WHEN OrgType=1 THEN
"{FILE:C:\messagefolder\OrgType22textfile.txt}" WHEN Name=Cheryl THEN
{Field1} ELSE THEN "sorry, you make too much money to get the discount."
END}
49