How to program if statement in mergefield

Y

YaHootie

A Newbie trying to make a Envelope Mail Merge document. I want to be able to
print the Surname of females followed by their Married Names. If Male then
only the Surname should print. The fields I have set up in my Excel database
are: Fname, Lname, Sex (M or F), Spouse Lname. Trying to follow MS help menu
but not helping much. Would someone give me the syntax I would use in the
MERGEFIELD area. Thank you in advance for any assistance.
 
P

Peter Jamieson

Something like:

{ MERGEFIELD Lname }{ IF { MERGEFIELD Sex } = "F" " { MERGEFIELD "Spouse
Lname" }" "" }

All the {} need to be the special field braces you can enter using ctrl-F9

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a Envelope Mailmerge 2
Complicated Formula - If statements 1
Is it possible to insert a line break into a mergefield? 3
Setting up the following expression in a query 2
# Range inside "Nested If" Statement 2
If statement using switches in Mergefields 2
Zip Code formatting Problem Word 2007 5
IF Statement 5

Top