I am trying to deal with a range of age in a mail merge. Specifically, I want "Juvenile, " to appear on our subpoenas, if the person being subpoenaed is between the ages of 0 and 18. I have to include zero because some date of births are blank. I wrote the following code in the mail merge. Everything works, expect it throws a { in front of the people who are note juveniles. The extra bracket in the title is facing the wrong way. It should be facing {.



{ Mergefield TableStart_Case }

{ Mergefield "TableStart_Witnesses" }

{ IF { Mergefield "Wtns_age" } > 0 "Juvenile" { IF {Mergefield "Wtns_age" } < 18 "Juvenile"}}

{Mergefield "TableEnd_Witnesses" }

{Mergefield "TableEnd_Case"}

I tried removing the second bracket after the second “Juvenile”, but that did not fix the problem. I still get the bracket. Any help is appreciated. Thank you

Kurt

If you're getting { in the output, that would only be because someone typed the { instead of using Ctrl-F9 to create a field brace pair (i.e. { }). As for your field construction, it should be:
{IF{MERGEFIELD "Wtns_age"}> 0 {IF{MERGEFIELD "Wtns_age"}< 18 "Juvenile"}}
As you have coded it, if the fields had been created properly, the output would be 'Juvenile' regardless of age.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Your code worked great for me! Thanks for your help. Also, I did not know about the F9 thing, which was also a great help. I do have one more questions. If the person is a juvenile, I would like for the code to display the age. Ideally, it will be displayed as (2), but I would be happy with just 2. Two in the example is the age. Thanks again for any help!

Kurt

That's as simple as:
{IF{MERGEFIELD "Wtns_age"}> 0 {IF{MERGEFIELD "Wtns_age"}< 18 "Juvenile ({MERGEFIELD "Wtns_age"})"}}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]