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?

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
"J&L" wrote in message
...
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 wrote:
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

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





"J&L" wrote in message
...
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?