Inserting a Salutation

Dismiss this until next updateThis documentation has been updated

The latest version of PrintShop Mail is currently 7.1. This documentation was updated on 2011-03-29 and covers the changes made in this version. If you are still using an older version of PrintShop Mail, you can access its documentation by using the Version: menu at the top-right corner of this screen.

If you wish to upgrade to PrintShop Mail7.1, you can do so via the Upgrade Request page. Note that in order to upgrade, you will need a valid OL Care contract as of 2010-09.

You can generate salutations with a conditional IF statement. If you have a field in your database that specifies the gender of the person, you can use it to add 'Mr.' or 'Mrs.' to the name.

Example

This example uses the IF function in combination with the "&" operator, which allows you to combine text strings.

This will result in a string that always starts with Dear , continues with either Mr. or Mrs. depending on the gender, and always finish with the first name, then a space, then the last name:

First Name	Last Name	Gender
John	Abrahams	M
Theresa	Johnson	F
William	Fremont	M

First Name	Last Name	Gender	Result
John	Abrahams	M	Dear Mr. John Abrahams
Theresa	Johnson	F	Dear Mrs. Theresa Johnson
William	Fremont	M	Dear Mr. William Fremont