[elfmajesty]

Doug,
Thank you for your post. I see what you are I'm very familiar with ctl+F9
but I'm not sure I understand what you mean about EACH pair. Does that mean
I will have to highlight the whole string when finished and ctl+F9 that to
enclose it? So, if I'm reading correctly, in your example I would need to do
the ctl+F9 seven (7) times. I've done this and I am still getting strange
results.

Also, I seem to recall this being MUCH easier in Word 2000. I noticed in
Word 2003 on the Mail Merge toolbar that I have the Insert Word Field button.
That brings me to the IF-THEN-ELSE wizard. Can I use that to write the
statement? What's throwing me is the "Compare To" section (see below)

If:
Field Name: [Title]
Comparison: [is blank]
Compare to: [what do I put here?]
Then:
Insert Text: [which I want to be the FirstName field]
Otherwise: [which I want to be the Title field plus a space]

Thanks for any advice. I'm continuing to work on this.
Elf

"Doug Robbins - Word MVP" wrote:

You should be using:

{IF {MERGEFIELD "Title"}= "" "{MERGEFIELD "FirstName"} {MERGEFIELD
"LastName"}" "{MERGEFIELD "Title"} {MERGEFIELD "FirstName"} {MERGEFIELD
"LastName"}" }

You must use Ctrl+F9 for each pair of field delimiters.
--
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

"elfmajesty" wrote in message
...
By the way, I am using Graham's website advice and have formatted the
first
line as follows:

{MERGEFIELD "Title"}{IF {MERGEFIELD "Title"}= "" "" " "} {MERGEFIELD
"FirstName"} {MERGEFIELD "LastName"}

and I am getting as a result:

Mr.MERGEFIELD John Doe

"elfmajesty" wrote:

Hello. I have an easy one - just can't remember how to do it!! I have
created a mail merge Label and set up my fields. We are including the
Title
field in our set-up. However, some of the data does not use the Title
field
(i.e. Mr. John Doe - [Title First Last] versus Jane Smith - [First
Last]). I
need to use (I think!) the If-Then-Else to say if the Title field is
blank,
move to the First Name field and DO NOT leave a blank space. What we are
getting right now after the merge is show below.

Mr. John Doe
123 Some Street
City, State Zip

Jane Smith
123 Some Street
City, State Zip

(Note the space where the Title field should be)

We need:

Mr. John Doe
123 Some Street

Jane Smith
123 Some Street

Can someone help me out??
Thanks!