[donna]

I am attempting use an if statement

In total this is looking at the SPOUSE field if it is not empty then Mr. &
Mrs., also IF GENDER is not "m" then Ms. if it is "m" then Mr. IF GENDER is
empty the populate with the data in the First_Name field.

This is what I have but it's not working.

Dear { IF {MERGEFIELD Gender} "m" "Ms." "Mr." }{ IF {MERFIELD Gender} = ""
{MERGEFIELD Owner_First_Name}{ IF {MERGEFIELD Spouse} "" "& Mrs." ""} = ""
{ MERGEFIELD Owner_First_Name } «Owner_Last_Name»,

Is this possible?

[macropod]

Hi Donna,

Try:

Dear {IF{MERGEFIELD Spouse} "" "Mr. & Mrs." "{IF{MERGEFIELD Gender}= m Mr.
Ms.} {MERGEFIELD Owner_First_Name}"} {MERGEFIELD Owner_Last_Name}

or, if your 'Spouse' field holds the (female) spouse name and you want it
displayed:

Dear {IF{MERGEFIELD Spouse} "" "Mr. {MERGEFIELD Owner_First_Name} & Mrs.
{MERGEFIELD Spouse}" "{IF{MERGEFIELD Gender}= m Mr. Ms.} {MERGEFIELD
Owner_First_Name}"} {MERGEFIELD Owner_Last_Name}

Cheers

--
macropod
[MVP - Microsoft Word]


"Donna" wrote in message
...
I am attempting use an if statement

In total this is looking at the SPOUSE field if it is not empty then Mr. &
Mrs., also IF GENDER is not "m" then Ms. if it is "m" then Mr. IF GENDER
is
empty the populate with the data in the First_Name field.

This is what I have but it's not working.

Dear { IF {MERGEFIELD Gender} "m" "Ms." "Mr." }{ IF {MERFIELD Gender} =
""
{MERGEFIELD Owner_First_Name}{ IF {MERGEFIELD Spouse} "" "& Mrs." ""} =
""
{ MERGEFIELD Owner_First_Name } «Owner_Last_Name»,

Is this possible?