Age Range and An Extra } is Appearing

KurtWoodfin · #1 04-03-2018, 08:23 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Find if Date range falls within another range	Triadragon	Excel	3	05-02-2016 11:48 AM
Name a Range in a Word Document and then copy that range to the end of the doc w button click	DanNatCorning	Word VBA	1	04-29-2016 10:47 PM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
extra space before equation	Nice2007	Word	1	04-27-2012 05:05 PM