Mail Merge Blank Lines

B

Bill

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
 
G

Graham Mayor

You need a nested field including the line feed

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

looks about right :)


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top