View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default IF Condition Question

Use

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


--
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

"Trudy" wrote in message
...
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 }"