IF Condition Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trudy - 13 Jun 2006 22:51 GMT

We are having a problem with an Outlook address/Word Mail Merge problem. In
the addresses that the recipient has a middle initial, the merge works fine.
When there is no middle initial, two spaces are being inserted between the
first and last names instead of one.

Could someone tell me what is wrong with the below? The middle initial is a
separate field.

The first condition is:
{ IF { MERGEFIELD Middle_Initial } = " " { MERGEFIELD First_Name }" " {
MERGEFIELD Last_Name }"

The second condition is:
" { MERGEFIELD First_Name }" " { MERGEFIELD Middle_Initial" "{ MERGEFIELD
Last_Name }"

Reply to this Message

Doug Robbins - Word MVP - 14 Jun 2006 04:41 GMT

Use

{ MERGEFIELD First_Name } { IF { MERGEFIELD Middle_Initial } = "" "{
MERGEFIELD Last_Name }" "{ MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }" }

Signature

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

> We are having a problem with an Outlook address/Word Mail Merge problem.
> In
[quoted text clipped - 14 lines]
> " { MERGEFIELD First_Name }" " { MERGEFIELD Middle_Initial" "{ MERGEFIELD
> Last_Name }"

Reply to this Message

Graham Mayor - 14 Jun 2006 06:33 GMT

There is no 'middle_initial' field normally associated with merges from
Outlook - see http://www.gmayor.com/mailmerge_from_outlook.htm

However the correct syntax would be

{Mergefield First_Name}{IF {Mergefield Middle_Initial} <> ""
"<space>{Mergefield Middle_Initial}"}<space>{Mergefield Last_Name}

Replace <space> with real spaces

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> We are having a problem with an Outlook address/Word Mail Merge
> problem. In the addresses that the recipient has a middle initial,
[quoted text clipped - 11 lines]
> " { MERGEFIELD First_Name }" " { MERGEFIELD Middle_Initial" "{
> MERGEFIELD Last_Name }"

Reply to this Message

Trudy - 14 Jun 2006 14:45 GMT

I found a very simple answer on the web last night. I tested it and it works
perfectly. Thanks to everyone!

http://www.hillsdale.edu/its/tips/mmspace.asp

> There is no 'middle_initial' field normally associated with merges from
> Outlook - see http://www.gmayor.com/mailmerge_from_outlook.htm
[quoted text clipped - 21 lines]
> > " { MERGEFIELD First_Name }" " { MERGEFIELD Middle_Initial" "{
> > MERGEFIELD Last_Name }"

Reply to this Message