About expressions in PrintShop Mail

Expressions allow you to manipulate text and data from the database.

They also allow you to add conditions to database fields for example, to create a salutation based on a 'Gender' field.

The expression is the combination of functions that make up the calculation.

Here is a valid example of an expression, made up of functions:

IF(UPPER([GENDER]) = "M", "Dear Mr" & PROPER([LAST_NM]), "Dear Mrs" & PROPER([LAST_NM] ))

The functions used in the example are:

1. IF(logical_test, value_if_true, value_if_false)

2. PROPER(string_value)

3. UPPER(string_value)

There are various function types available, depending on the expression you want to create.

• Barcode Functions

• Layout Functions

• Logical Functions

• Number Functions

• String Functions

You can also pick from a list with all functions, see:

• Functions Overview