#1
|
|||
|
|||
Using IF to make bold
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Thanks
Thank you for your help. It now works just fine and dandy.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Format Bold in one line makes all lines bold | Nitte | Word | 2 | 02-07-2013 12:34 AM |
How to I make text Bold in a User Form -Visual Basic | gurp99 | Word VBA | 11 | 03-12-2012 04:05 PM |
Using replace to make a word bold and its proceeding character. | bostonboi | Word | 1 | 01-16-2011 01:54 PM |
How to make a list of all the bold words in a document? | galaxy_110 | Word | 1 | 12-31-2010 08:23 AM |
Autocorrect to make words Bold? | GB89 | Word | 1 | 04-15-2010 09:04 PM |