Mail Merge Blank Lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 19 Jan 2004 03:31 GMT

Hi,
Hope someone can help

In a " If Then Else statement:

If (field = "A") OR (field = "B") then
Bill
Else
""
End IF

When the statement is true I want to print "Bill".

Whenever the statement is false I don't want to print
anything.

So in a data source having 5 lines and "Bill" appears
only twice.

I'd like to see:

Bill
Bill

Not:

Blank line
Blank Line
Bill
Blank Line
Bill

What do I do to elimiinate the blank Lines?

Thank you in advance,
Bill

Reply to this Message

Graham Mayor - 19 Jan 2004 06:38 GMT

You need a nested field including the line feed

{IF {Mergefield Fieldname} = "A" "Bill
" "{IF {Mergefield Fieldname}= "B" "Bill
" ""}"}

looks about right :)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi,
> Hope someone can help
[quoted text clipped - 32 lines]
> Thank you in advance,
> Bill

Reply to this Message