Prevent blank lines with conditional if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl - 16 Apr 2004 15:24 GMT

If I create my mailmerge without hard returns like this:

«Prefix»«First» LastTitleTitle2OrganizationOrganization2StreetStreet2Street3«City»,
«State» «Zip»

I can prevent blank lines from showing up where there is no value for
the merge code.

But I want to set it up like this with hard returns in the unmerged
document so the address spacing is correctly viewed. Can anyone tell
me how to do this, so if there is no title2, it doesn't put a blank
line in?

«Prefix»«First» Last
Title
Title2
Street
«City», «State» «Zip»

Thanks in advance for the help!
Carl

Reply to this Message

Graham Mayor - 17 Apr 2004 08:22 GMT

Your message title suggests the answer. You need to insert a conditional
field. Set up the merge as follows:

?Prefix? ?First? ?Last?
?Title?{IF {Mergefield Title2} <> "" "
{Mergefield Title2}"}
?Street?
?City?, ?State? ?Zip?

The field boundaries are inserted with CTRL+F9 - toggle the display between
field and content with ALT+F9

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> If I create my mailmerge without hard returns like this:
>
[quoted text clipped - 18 lines]
> Thanks in advance for the help!
> Carl

Reply to this Message

Rate this thread: