View Single Post
  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP on news.microsoft.com Doug Robbins - Word MVP on news.microsoft.com is offline
external usenet poster
 
Posts: 407
Default "remove blank lines"+"Mail Merge"

If you want to send me a copy of the mail merge main document, I will see
what I can do with it.

Send it to

You must delete REMOVECAPS from the email address.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"John" wrote in message
...
Doug,

Thanks. But it is still not working. I even tried to remove the spaces
at
the beginning of the line (which brought the 'columns' of salary data
which
were previously indented (on purpose) over to the left and there are still
blank lines between the amounts. The text on the lines don't show- which
is
what I want - but the lines themselves still take up a 'line' on the
document.

Peter - if "don't print blank lines" is the default in MS Word 2007 id
doesn't work very well - or MS Word doesn't consider a line with an
IF-THEN-ELSE on it 'truly blank'.

Thanks for your responses.

John


"Doug Robbins - Word MVP on news.microsof" wrote:

On the PREVIOUS line, put

{IF {MERGEFIELD merit_pay} 0 "Merit ${MERGEFIELD merit_pay }" "" }

Then put the cursor between the " and the M of Merit and press Enter so
that
with Formatting marks being shown (Press the Show/Hide ¶ button), you see

Previous text { IF { MERGEFIELD merit_pay } 0 "¶
Merit ${ MERGEFIELDmerit_pay }" "" }

Press Alt+F9 to toggle off the display of the field codes and then
execute
the merge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"John" wrote in message
...
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