"IF" clause

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louise - 02 Mar 2004 15:57 GMT

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,

Reply to this Message

Graham Mayor - 02 Mar 2004 16:13 GMT

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}

Signature

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

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

> I am using Office XP. When I merge a letter, the name
> does not always contain a Middle Initial and it leaves a
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message