How do I remove or supress blank data in fields in mail merge e.g.

[J&L]

I have a some people with middle names and some that don't. When I merge the
data in Word 2003 it shows an extra space! How do I supress blank data?

 

[Doug Robbins]

Use an If...then...else field.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Graham Mayor]

Use an If...then...else field.


Hope this helps,
Doug Robbins - Word MVP

eg
{Mergefield First_Name}{IF {Mergefield Middle_Name} <> "" " {Mergefield
Middle_Name}"} {Mergefield Last_Name}
Note the space before {Mergefield Middle_Name}
Change the field names to suit your data.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>