Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2020, 06:51 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 again


I think I have followed your example to the tee - thank you. (Well, in the actual code I have not inserted the tabs and the soft carriage return. They actually create some issues in the output ...) No different outcome I'm afraid - just coloured text on the white page background of the document..


I have attached a screenshot of the mail merge code in the table cell.


I have also attached a screenshot of a sample page output. As you can see the text colour is the colour I am hoping the table cell will be shaded.


I may just be doing something really simple - but wrong ...



Thank you for your assistance ehre - much appreciated

Wayne
Reply With Quote
  #2  
Old 05-07-2020, 02:13 PM
macropod's Avatar
macropod macropod is offline Colour code mail merge header table cell backgrounds Windows 7 64bit Colour code mail merge header table cell backgrounds Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by FredNerk View Post
No different outcome I'm afraid - just coloured text on the white page background of the document.
All that tells me is that you're colouring the text instead of highlighting it. Look at the document in the link I posted.
Quote:
Originally Posted by FredNerk View Post
I have attached a screenshot of the mail merge code in the table cell.

I have also attached a screenshot of a sample page output.
There is nothing attached to your post.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-07-2020, 04:27 PM
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 Thank you

Morning


Sorry, I just don't get it - I think I have attached the two screen prints from last night correctly this time.


I think the logic of all of this sums up why programming was never my forte ...


Thank you for all your assistance with this. I look at the other attachment and to me it is as clear as mud - well, perhaps not that muddled, but I still cannot see why this is not working.


Cheers
Attached Images
File Type: png Screen Shot 2020-05-07 at 9.43.09 pm.png (106.7 KB, 37 views)
File Type: png Screen Shot 2020-05-07 at 9.48.44 pm.png (112.1 KB, 34 views)
Reply With Quote
  #4  
Old 05-07-2020, 10:47 PM
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

Hello Paul


The shading of the cell is now working really well. Thank you!



I am having difficulty centering that selection in the table cell - height is OK, but I cannot get it centred across the page. Are there controls within \*CHARFORMAT that I can use do you think?


Thank you - regards




Wayne
Reply With Quote
Reply



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 04:33 AM.


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