I am new to MERGEFIELD in MailMerge. I am trying to use an If statement to say that if the patient's heart rate is above 80 then make the heart rate Red and bold, otherwise make the heart rate black and not bold. The MailMerge field is called HR.I use the Ctrl and F9 to insert { brackets. The Word doc uses an Excel spreadsheet as its data source.

The syntax I have played about with is:



{If {MERGEFIELD HR}>80{MERGEFIELD HR} {MERGEFIELD HR}}

However despite various versions of the syntax II keep getting the error message:

Error! Unknown op code for conditional.

The mergefield is in the cell of a table, although I can't see this has any effect

What am I doing wrong? Thanks for any help.

The basic issue is a missing spaces. The minimum requirement is:
{IF{MERGEFIELD HR}> 80 {MERGEFIELD HR} {MERGEFIELD HR}}
You could also use:
{={MERGEFIELD HR}-80 \# "'{MERGEFIELD HR}';'{MERGEFIELD HR}'"}

Note: The field brace pairs (ie '{ }') for the above examples are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.

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

Thank you for your help. It now works just fine and dandy.