Supress the blank space from a blank data field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 26 Jul 2005 20:31 GMT

My wife is using an Excel data source to create a Word mail merge.

She needs to supress the blank space that is created from a blank middle
initial field. All the anwers I've found here deal with blank LINES not
spaces.

How can she do what she wants?

Thanks,

Signature

John

Reply to this Message

Graham Mayor - 27 Jul 2005 07:33 GMT

You need a conditional field. Assuming fieldnames firstame lastname and
initial

{Mergefield Firstname} {IF {Mergefield Initial} <> "" "{Mergefield Initial}
"}{Mergefield Lastname}

Note the space before the closing quote.

Signature

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

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

> My wife is using an Excel data source to create a Word mail merge.
>
[quoted text clipped - 5 lines]
>
> Thanks,

Reply to this Message

John - 27 Jul 2005 12:30 GMT

Graham,

Many thanks from both of us.

Signature

John

> You need a conditional field. Assuming fieldnames firstame lastname and
> initial
[quoted text clipped - 13 lines]
> >
> > Thanks,

Reply to this Message

Longwood Pam - 20 Sep 2005 16:31 GMT

HELP! I have the same problem. I'm using Office 2000 and am creating
envelopes in Word using an Excel spreadsheet as my data source. When I
insert my merge fields, there are no brackets {} as shown below. I have
tried copying exactly what is on the sample below, but all of the characters
(carrots, quotes, brackets, etc) print on the evelope. Each of my merge
fields is bracketed by double "baby" carrots (I don't have that key on my
keyboard so I can't show you what I mean). I have tried to modify the
example below according to the format I have, but the word IF prints on the
envelope or I still get that space if there is no middle initial. I tried
researching "conditional field" in the help section of the application, but
no luck. I don't know what else to try! Thanks!

> You need a conditional field. Assuming fieldnames firstame lastname and
> initial
[quoted text clipped - 13 lines]
> >
> > Thanks,

Reply to this Message