#1
|
|||
|
|||
MailMerge Conditional Formatting
Hello,
I wish to be able to set a MailMerge field to Bold, depending on the contents of the field. If the contents of the field begin with "Text" then the field should appear in bold, otherwise the field should appear as normal. I have tried the following, among other attempts but, this always shows the fields in bold, regardless of contents: {IF {MERGEFIELD Description} = "Text*" {MERGEFIELD Description}{MERGEFIELD Description}\* MERGEFORMAT} my research suggests that this should work but, obviously it doesn't. I can't work out where I'm going wrong. Any suggestions will be much appreciated. Graham |
#2
|
||||
|
||||
Lose the Mergeformat switch and add quotes around the results e.g.
{IF {MERGEFIELD Description} = "Text*" "{MERGEFIELD Description}" "{MERGEFIELD Description}"}
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thank you for that. Just what I was looking for, only I couldn't seem to find the right combination.
Graham |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is there any way to make mailmerge look at all rows for formatting? | devief | Mail Merge | 1 | 08-28-2019 02:02 AM |
Help Formatting Time in A MailMerge Field | JennEx | Mail Merge | 4 | 05-21-2018 06:47 PM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting. | Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Problem With Formatting Mailmerge Fields | revans611 | Mail Merge | 0 | 05-31-2009 06:20 PM |