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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J&L - 13 Jan 2005 22:21 GMT

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?

Reply to this Message

Doug Robbins - 14 Jan 2005 00:50 GMT

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

Signature

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

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

Reply to this Message

Graham Mayor - 14 Jan 2005 06:04 GMT

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

Signature

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

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

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

Reply to this Message