#16
|
|||
|
|||
Thank you Paul - I got it! :-)
it is working! Now, a further question on this please if I may - the ouput is good, but "ragged" in the cell as I have centred the output in a reasonably wide cell. There are some job/document titles that are quite lenghty. I am not certain there is an easy answer to this but can the entire cell be shaded from within this mail merge code? Thank you for your insight and assistance Paul - regards Wayne |
#17
|
|||
|
|||
Actually, hold that thought please Paul - I think that is why you were padding out the field with Tabs and soft returns ... Correct?
Wayne |
#18
|
||||
|
||||
Correct. Otherwise the cell won't all have the highlight. Read closely, post #2.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#19
|
|||
|
|||
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 |
#20
|
||||
|
||||
The centring can only be done via tabs, for which you should use a centre-aligned tab-stop. The \* Charformat switch is only for character formatting.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#21
|
|||
|
|||
Thank you
Cheers |
#22
|
|||
|
|||
Hi Paul thanks for your guidance on this, but I am also having issues.
Can I just ask is it possible for a table shading of orange color or it's not possible due to the fact the way it's driven is by Highlighting text? I appreciate your response. |
#23
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#24
|
|||
|
|||
Quote:
|
#25
|
||||
|
||||
Quote:
Quote:
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#26
|
|||
|
|||
Hi Paul,
I've read every thread on this I can find - have you done a youtube tutorial on it? I generally find them easier to follow as I'm very new to this. I have tried to attach a screenshot of what I've done here - it highlights the text, but I need the cell shaded. I don't understand how/what to do with the tab/enter commands to create the shading or exactly what keys to use. If I try copy/pasting your tab/enter symbols, they just display in the highlighted output. If I try to actually press the tab key, it just selects the next table cell. |
|
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 |