Mail Merge If / Else Question / Gender Specific?
Use
{ IF { MERGEFIELD gender } = "" { MERGEFIELD First_Name } { IF { MERGEFIELD
gender } "m" "Ms," "Mr." } }
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"romeshomey" wrote in message
...
Basically I have a document where I have mail merged the gender column to
the
Dear Mr. / Mrs. area of the document.
I have it working where if the Gender column is male is assigns a Mr. or
if
not male it assigns a Mrs. as so.
{ IF m "m" "Ms." "Mr." }
Problem is, alot of the Genders are blank in the source, so where the
Gender
column is blank I want it to assign the First_Name from another column
instead.
So for instance.
If the gender is m or f it assigns Mr. or Mrs., but if no gender is
defined
in the column, it assigns First_Name from the First_Name column instead.
I am baffled.
|