Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to hide a merge field
I would like to hide a field in a merge, but only if it's =0 in my Excel
spreadsheet. Otherwise, I would like the filed to show up as it normally would. An IF statement with " " (quotes around a blank) doesn't seem to be cutting it. Any suggestions? (Couldn't find anything on a couple of the MVP sites referenced throughout this board.) |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to hide a merge field
You can use a formatting switch on a numeric field
eg {Mergefield Fieldname \# "0.00"; This is covered on my web site at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdicke wrote: I would like to hide a field in a merge, but only if it's =0 in my Excel spreadsheet. Otherwise, I would like the filed to show up as it normally would. An IF statement with " " (quotes around a blank) doesn't seem to be cutting it. Any suggestions? (Couldn't find anything on a couple of the MVP sites referenced throughout this board.) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to hide a merge field
Your suggestion of {Mergefield Fieldname \# "0.00";;} didn't work. And I
didn't see anything on your site that really showed what I was looking for. Here's my field as it currently stands, and works returning me the correct data: { MERGEFIELD O_08 \# $##.00 } What I'd like to do (or think I need to do) is something like this: { IF { MERGEFIELD O_08 = 0 "" { MERGEFIELD O_08 \# $##.00 } } or mabye just: { IF { MERGEFIELD O_08 = 0 "" \# $##.00 } Whatever the case, I can't get the filed blank if there's a zero in that cell. Thanks. Matt "Graham Mayor" wrote: You can use a formatting switch on a numeric field eg {Mergefield Fieldname \# "0.00"; This is covered on my web site at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdicke wrote: I would like to hide a field in a merge, but only if it's =0 in my Excel spreadsheet. Otherwise, I would like the filed to show up as it normally would. An IF statement with " " (quotes around a blank) doesn't seem to be cutting it. Any suggestions? (Couldn't find anything on a couple of the MVP sites referenced throughout this board.) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to hide a merge field
OK
{ IF { MERGEFIELD O_08 } 0 { MERGEFIELD O_08 \# "$,0.00"} } If you want zeros suppressing also, add in the semi-colons to the switch -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdicke wrote: Your suggestion of {Mergefield Fieldname \# "0.00";;} didn't work. And I didn't see anything on your site that really showed what I was looking for. Here's my field as it currently stands, and works returning me the correct data: { MERGEFIELD O_08 \# $##.00 } What I'd like to do (or think I need to do) is something like this: { IF { MERGEFIELD O_08 = 0 "" { MERGEFIELD O_08 \# $##.00 } } or mabye just: { IF { MERGEFIELD O_08 = 0 "" \# $##.00 } Whatever the case, I can't get the filed blank if there's a zero in that cell. Thanks. Matt "Graham Mayor" wrote: You can use a formatting switch on a numeric field eg {Mergefield Fieldname \# "0.00"; This is covered on my web site at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdicke wrote: I would like to hide a field in a merge, but only if it's =0 in my Excel spreadsheet. Otherwise, I would like the filed to show up as it normally would. An IF statement with " " (quotes around a blank) doesn't seem to be cutting it. Any suggestions? (Couldn't find anything on a couple of the MVP sites referenced throughout this board.) |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to hide a merge field
PERFECT! Thank you!
"Graham Mayor" wrote: OK { IF { MERGEFIELD O_08 } 0 { MERGEFIELD O_08 \# "$,0.00"} } If you want zeros suppressing also, add in the semi-colons to the switch -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdicke wrote: Your suggestion of {Mergefield Fieldname \# "0.00";;} didn't work. And I didn't see anything on your site that really showed what I was looking for. Here's my field as it currently stands, and works returning me the correct data: { MERGEFIELD O_08 \# $##.00 } What I'd like to do (or think I need to do) is something like this: { IF { MERGEFIELD O_08 = 0 "" { MERGEFIELD O_08 \# $##.00 } } or mabye just: { IF { MERGEFIELD O_08 = 0 "" \# $##.00 } Whatever the case, I can't get the filed blank if there's a zero in that cell. Thanks. Matt "Graham Mayor" wrote: You can use a formatting switch on a numeric field eg {Mergefield Fieldname \# "0.00"; This is covered on my web site at http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdicke wrote: I would like to hide a field in a merge, but only if it's =0 in my Excel spreadsheet. Otherwise, I would like the filed to show up as it normally would. An IF statement with " " (quotes around a blank) doesn't seem to be cutting it. Any suggestions? (Couldn't find anything on a couple of the MVP sites referenced throughout this board.) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide XE field | Microsoft Word Help | |||
HIDE To AND Cc FIELD IN A MAIL | Microsoft Word Help | |||
Hide Merge Field Code In Printed Document | Microsoft Word Help | |||
TOC field codes will not hide when commanded by HIDE/SHOW tile. | Microsoft Word Help | |||
HOW TO HIDE Field Codes automatically? | Mailmerge |