If Fields

[Stansdl]

I have a data set that is set up like this
Name, Title, address, City, Zip

If the Title matches say President I want the greeting to be Dear President
otherwise I want it to read Dear Name (matching the name in the name field)

How can I do this?

 

[macropod]

Hi Stansdl,

You could do this using an IF field, in conjunction with your «Title» and «Name» mergefields.

For a test of the 'President' title, you could code the field as:
{IF«Title»= "President" "President" «Name»}

More generally, if you simply want to insert the title, if there is one, and the name otherwise, you could code the field as:
{IF«Title»<> "" «Title» «Name»}

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.