Suppress Blank Lines

[JimPNicholls]

H

I'm useing Word 97 and my Datasource is in Excel 97. The letter I'm producing is set up in a table. One of the mergefields have the following condition applied to it

{ IF { Mergefield Renewal Prem } > 0 "{ Mergefield Renewal_Prem }" ""

Obviously from the formula, if the mergefiled is less than or equal to "0", I don't want to output the mergefield. This works fine but then I'm left with a blank line in my table. Is there any way to remove/supress the blank line if there is no value in it?

 

[Graham Mayor]

You are almost there - what you need to do is include the paragraph in the
field so that there is only a line break when there is content in the field
eg

IF { Mergefield Renewal Prem } > 0 "{ Mergefield Renewal_Prem }
" "" }

The conditional field goes immediately after the previous field, on the same
line.




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

 

[JimPNicholls]

I think I know what your trying to explain, but isn't that assuming that my next paragraph is in the same cell? If each line of text is within a different cell can an empty cell be suppressed

If not thanks for the help anyway, I'll just merge the whole paragraph into the same cell and add the carriage return within the formula

Cheers

----- Graham Mayor wrote: ----

You are almost there - what you need to do is include the paragraph in th
field so that there is only a line break when there is content in the fiel
e

IF { Mergefield Renewal Prem } > 0 "{ Mergefield Renewal_Prem
" ""

The conditional field goes immediately after the previous field, on the sam
line




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

JimPNicholls wrote