Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Suppress Blank Lines

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JimPNicholls - 31 Dec 2003 11:06 GMT
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 - 31 Dec 2003 11:20 GMT
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.

Signature

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

> Hi
>
[quoted text clipped - 9 lines]
> 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?
JimPNicholls - 31 Dec 2003 11:51 GMT
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 gmayor@mvps.or
          Web site www.gmayor.co
      Word MVP web site www.mvps.org/wor
    <>><><<>><<><>><><<><>><<>><><<
   
    JimPNicholls wrote
    > H
    >> I'm useing Word 97 and my Datasource is in Excel 97. The letter I'
    > producing is set up in a table. One of the mergefields have th
    > following condition applied to it
    >> { IF { Mergefield Renewal Prem } > 0 "{ Mergefield Renewal_Prem }" "
    >
    >> Obviously from the formula, if the mergefiled is less than or equa
    > to "0", I don't want to output the mergefield. This works fine bu
    > then I'm left with a blank line in my table. Is there any way t
    > remove/supress the blank line if there is no value in it

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.