Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2020, 02:34 AM
FredNerk FredNerk is offline Colour code mail merge header table cell backgrounds Mac OS X Colour code mail merge header table cell backgrounds Office 2016 for Mac
Novice
 
Join Date: May 2020
Posts: 10
FredNerk is on a distinguished road
Default

Hi Paul


Yes, what I included was how I got to get the text the colour I was seeking. I tried your suggested script (and similar posts of your s I think form another site), with the changed "IF" statements but I could just not get it working properly.





So, following your code example and my variables, will it be as simple as this for just the first conditional statement?



{ IF {MERGEFIELD DocName} = { " { MERGEFIELD DocName } " \*CHARFORMAT }


Sorry, my coding skills are pretty basic ...
Reply With Quote
  #2  
Old 05-07-2020, 02:58 AM
FredNerk FredNerk is offline Colour code mail merge header table cell backgrounds Mac OS X Colour code mail merge header table cell backgrounds Office 2016 for Mac
Novice
 
Join Date: May 2020
Posts: 10
FredNerk is on a distinguished road
Default

OK - well the text appeared as black on white background but no shading of the table cell


Wayne
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to immediately change the colour of a cell depending on the code placed in anothe Phil Payne Excel Programming 2 07-27-2013 11:04 PM
Mail Merge Code (Default Display) ochiha_ita Mail Merge 3 04-22-2013 04:04 AM
Colour code mail merge header table cell backgrounds Mail merge in a header Kizzy Mail Merge 1 08-13-2012 10:50 AM
Mail merge Field Code Manipulation macjnr Mail Merge 0 09-10-2009 11:37 AM
Colour code mail merge header table cell backgrounds Code for Changing Cell Backgrounds leroytrolley Excel 2 12-05-2008 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 PM.


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