"IF" clause

[Louise]

I am using Office XP. When I merge a letter, the name
does not always contain a Middle Initial and it leaves a
blank space when there is no MI. I have tried using the
IF, THEN insert but I still get a blank space. So
frustrating. Can anyone help? The data source is Excel.

Thanks,

 

[Graham Mayor]

You are halfway there with the conditional field. You use the field to
insert the mergefield AND the space.

{Mergefield FirstName}{IF {Mergefield Initial}<> "" " {Mergefield Initial}"}
{Mergefield LastName}
or to clarify
{Mergefield FirstName}{IF {Mergefield Initial}<> "" "<space>{Mergefield
Initial}"}<space>{Mergefield LastName}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>