View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John John is offline
external usenet poster
 
Posts: 307
Default "remove blank lines"+"Mail Merge"

Peter and macropod,

Thanks. I tried both and I got 'closer' but MS Word 2007 wouldn't always
line the data up properly and other times it would throw an additional '$' on
the line.

I've seen several posts about a feature that perhaps other (prior) versions
of MS Word had and either 2007 hides it or I just can't find it. The feature
I wanted to try was a switch that said "Don't print blank lines". I've
searched high and low and can't seem to find that switch. I'm not saying it
would solve my problem but I would like to turn it on (if it exists in MS
Word 2007).

Many thanks.
--
John


"macropod" wrote:

Hi John,

You could use:
{IF«merit_pay» 0 "«merit_pay»¶
"}
or:
{MERGEFIELD merit_pay \# "'Merit $',0.00¶
;;"}
where the '¶' is an actual carriage return or manual line-break.

--
Cheers
macropod
[MVP - Microsoft Word]


"John" wrote in message ...
I've got a mail merge document that has a separate line for some numeric
amounts
(Base Pay, Adjustment, Merit Pay, etc.). The IF-THEN-ELSE statement I am
using works: ({IF {MERGEFIELD} merit_pay} 0 "Merit ${MERGEFIELD}
merit_pay}"""}
but if merit_pay IS zero, it leaves a blank line in the document. How do I
get it to remove the blank line. The user wants all of the amounts to show,
on separate lines, lined up, but to not show any lines if there is no data on
that line AND she doesn't want the blank line to show either. She wants
subsequent lines to 'float up'.
--
John