Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2023, 12:46 PM
TargetedIT TargetedIT is offline MailMerge Conditional Formatting Windows 10 MailMerge Conditional Formatting Office 2019
Novice
MailMerge Conditional Formatting
 
Join Date: Jul 2023
Posts: 3
TargetedIT is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-28-2023, 03:40 AM
gmayor's Avatar
gmayor gmayor is offline MailMerge Conditional Formatting Windows 10 MailMerge Conditional Formatting Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 07-30-2023, 02:14 PM
TargetedIT TargetedIT is offline MailMerge Conditional Formatting Windows 10 MailMerge Conditional Formatting Office 2019
Novice
MailMerge Conditional Formatting
 
Join Date: Jul 2023
Posts: 3
TargetedIT is on a distinguished road
Default

Thank you for that. Just what I was looking for, only I couldn't seem to find the right combination.

Graham
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge Conditional Formatting Is there any way to make mailmerge look at all rows for formatting? devief Mail Merge 1 08-28-2019 02:02 AM
MailMerge Conditional Formatting Help Formatting Time in A MailMerge Field JennEx Mail Merge 4 05-21-2018 06:47 PM
MailMerge Conditional Formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
MailMerge Conditional Formatting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft