Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
"remove blank lines"+"Mail Merge"
You can try smething like the following instead:
{ MERGEFIELD merit_pay \#"'Merit $0.00';'';''" } (You can adjust the '$0.00' part as necessary) If you need the field to be inserted with its original formatting then you need the IF, but if for example you want A Merit $whatever B when merit_pay 0 and A B when it perit_pay = 0, you can use A{ IF { MERGEFIELD merit_pay } 0 " Merit ${ MERGEFIELD merit_pay }" "" } B i.e. click enter immediately before the "M" of "Merit to insert a paragraph mark in the output of the IF field. Peter Jamieson http://tips.pjmsn.me.uk John wrote: 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'. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email merge with multiple recipients in "To", "CC" & "BCC" | Mailmerge | |||
How do you print emails with headers ("From","To" &"Subject lines | Microsoft Word Help | |||
Word 2007: "Keep with next" and "Widow Lines" features not workin | Microsoft Word Help | |||
"mail merge" disappeared from "tools" menu | Mailmerge | |||
remove the "final with markup" and "read" views as defaults | Page Layout |