field inside another field

B

BAH

Hi

I'm using this formula for my mail merge:
{ IF { MERGEFIELD "grade"} < 10 "{ MERGEFIELD "grade"}" "{ MERGEFIELD
"grade"}" }
in which the second { MERGEFIELD "grade"} is in red to make every grade that
is below 10 appear in red. But I'm looking for a way to encircle those low
grades with a red circle. One way I found is by using this formula which I
took from the Extended Formatting toolbar in Word 2003:
{ eq \o\ac(â—‹,x)}
where x is the character to be encircled. I can make â—‹ red.

My question is how to embed the encircling formula into my main one. I tried
this but didn't work:
{ IF { MERGEFIELD "grade"} < 10 "{ eq \o\ac(â—‹,{ MERGEFIELD "grade"})}" "{
MERGEFIELD "grade"}" }
(with â—‹ in red).

Could anybody tell me where I'm going wrong, or if there's a smarter way to
do it?

Thanks a lot
 
P

Peter Jamieson

Some field types do not work within the results of { IF } fields. SOmetimes
you can work around that by nesting the IF field inside the other field,
e.g. you could try:

{ EQ { IF { MERGEFIELD "grade" } < 10 "\\o\ac(â—‹,{ MERGEFIELD "grade"})"
"\\l({ MERGEFIELD "grade" })" }}

NB, often you have to "double up" backslashes within merge fields but in
this case, doubling up the first backslash in each expression but not the
next backslash seems to do the trick.
 
B

BAH

Thanks; but it's not working.


Peter Jamieson said:
Some field types do not work within the results of { IF } fields. SOmetimes
you can work around that by nesting the IF field inside the other field,
e.g. you could try:

{ EQ { IF { MERGEFIELD "grade" } < 10 "\\o\ac(â—‹,{ MERGEFIELD "grade"})"
"\\l({ MERGEFIELD "grade" })" }}

NB, often you have to "double up" backslashes within merge fields but in
this case, doubling up the first backslash in each expression but not the
next backslash seems to do the trick.
 
B

BAH

CORRECTION CORRECTION

Your method DOES work. Thank you a lot Peter. My mistake! I thought the "l"
is the "|" (shift+backslash), but it turned out to be the letter L. Sorry
again (although I'm still wondering what the letter L is doing there).
Anyway, thank you very much.
 
P

Peter Jamieson

The \l means "list" - i.e. use a list with one entry just to insert the
plain text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top