Colour code mail merge header table cell backgrounds

macropod · #1 09-24-2021, 10:42 PM

The technique discussed in this thread is for changing the colour of the cell itself, via highlighting. For that, you're limited to Word's highlight options, which don't include orange.

Another possibility is to colour the text itself - for which your options are virtually unlimited. See the relevant discussions in the Mailmerge Tips & Tricks thread: https://www.msofficeforums.com/mail-...ps-tricks.html

jessenox0 · #2 09-24-2021, 10:57 PM

Quote:

Originally Posted by macropod

The technique discussed in this thread is for changing the colour of the cell itself, via highlighting. For that, you're limited to Word's highlight options, which don't include orange.

Another possibility is to colour the text itself - for which your options are virtually unlimited. See the relevant discussions in the Mailmerge Tips & Tricks thread: https://www.msofficeforums.com/mail-...ps-tricks.html

Thanks Paul, I am impressed that you remain active and still respond after all these years. Thank you so much for your dedicated, I am so impressed with your skills and responses. Paul, I really need orange for table shading so I guess VBA would be more of a goer. Do you provide VBA help as well? The table section i'd like color shaded is like the Second column of a table, has it's own table. I was thinking of vba but how on earth do I specific that specific area only. Any thoughts?

macropod · #3 09-24-2021, 11:47 PM

Quote:

Originally Posted by jessenox0

I am impressed that you remain active and still respond after all these years.

I'm actually no longer active. I responded only because the forum still notifies me of replies to discussions I've previously participated in.

Quote:

Originally Posted by jessenox0

Do you provide VBA help as well? The table section i'd like color shaded is like the Second column of a table, has it's own table. I was thinking of vba but how on earth do I specific that specific area only. Any thoughts?

It's not apparent to me what you mean by: "the Second column of a table, has it's own table".

Some generic code you could adapt is:

Code:

Sub MailMergeToDoc()
Application.ScreenUpdating = False
Dim Tbl As Table, r As Long
ActiveDocument.MailMerge.Execute
For Each Tbl In ActiveDocument.Tables
  With Tbl
    For r = 1 To .Rows.Count
      With .Cell(r, 2)
        If Split(.Range.Text, vbCr)(0) = "my condition" Then
          .Shading.BackgroundPatternColor = wdColorOrange
        End If
      End With
    Next
  End With
Next
Application.ScreenUpdating = True
End Sub

Note: As coded, the above macro intercepts Word's 'Edit Individual Documents' button to complete the merge and apply the shading.

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
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
Code for Changing Cell Backgrounds	leroytrolley	Excel	2	12-05-2008 02:05 AM