Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
using iif statement
Hi.
Can I tweak a mergefield contents so that if the field is blank it stays blank and if it contains a number it adds 1000000 to it? thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
using iif statement
You could try a nested field
{ IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD myfield }+1000000 }" } (all the {} need to be the special field braces you can insert using ctrl-F9. That won't work if your field can contain non-numeric text, e.g. " " or "abc" :-) Peter Jamieson "Boots" wrote in message ... Hi. Can I tweak a mergefield contents so that if the field is blank it stays blank and if it contains a number it adds 1000000 to it? thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
using iif statement
thanks for your response. I tried this
{ IF "{MERGEFIELD Control_Num}" = "" "" "{ ={ MERGEFIELD Control_Num }+1000000 }" } but ot deosn;t seem to work. I created the braces using ctrl + f9. Boots "Peter Jamieson" wrote: You could try a nested field { IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD myfield }+1000000 }" } (all the {} need to be the special field braces you can insert using ctrl-F9. That won't work if your field can contain non-numeric text, e.g. " " or "abc" :-) Peter Jamieson "Boots" wrote in message ... Hi. Can I tweak a mergefield contents so that if the field is blank it stays blank and if it contains a number it adds 1000000 to it? thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
using iif statement
Sorry it does work. I'd spelt control wrong. thanks
"Peter Jamieson" wrote: You could try a nested field { IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD myfield }+1000000 }" } (all the {} need to be the special field braces you can insert using ctrl-F9. That won't work if your field can contain non-numeric text, e.g. " " or "abc" :-) Peter Jamieson "Boots" wrote in message ... Hi. Can I tweak a mergefield contents so that if the field is blank it stays blank and if it contains a number it adds 1000000 to it? thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an If Statement | Mailmerge | |||
Q: IF statement in table in Word | Microsoft Word Help | |||
Possible BUG: Multiple HTTPrequests send from one includetext statement | Mailmerge | |||
How do I copy a scanned signature into an if/or statement in Word | Mailmerge | |||
Insert carriage return in mergefield statement | Mailmerge |