| 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 | |||
Linear Mode
