Inserting a Salutation

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

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

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

"Dear" & IF([Gender]="M", " Mr. ", " Mrs. ") & [First name] & " " & [Last name]

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	Result
John	Abrahams	M	Dear Mr. John Abrahams
Theresa	Johnson	F	Dear Mrs. Theresa Johnson
William	Fremont	M	Dear Mr. William Fremont