Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
if statement, if condition not met the show static text instead ofmergefield
I am merging from an access database into a word document. One merge
field, AmountClaimed, is numeric. If this mergefield = 0, I want Word to show "TBD" (without quotes), but if it is not = 0, then i want to show the mergefield AmountClaimed. This is what I have this is not working. I am messed up on the placement of all the brackets and quotes big time. I also dont know what delimited to put around my static text, right now its double quotes. { IF {MERGEFIELD AmountClaimed 0 "{MERGEFIELD AmountClaimed \# 0.00}" "{"TBD"}} When I hit the button to view Merged Data, i still just see the above mess of a conditonal. Any help would be greatly appreciated. Thanks! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
if statement, if condition not met the show static text insteadof mergefield
nevermind, i just found that "Insert Word Field" option for If
statements and I think i have it working... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert auto paragraph numbering to static text numbers? | Microsoft Word Help | |||
Some static text boxes, some free text | New Users | |||
convert bibliography to static text | Microsoft Word Help | |||
statement only show up on the last page in the footer | Microsoft Word Help | |||
Replace Static with Variable but leave alone text between them | Microsoft Word Help |