![]() |
|
|
|
#1
|
||||
|
||||
|
As this appears to be the result of a mail merge, by using https://www.gmayor.com/MergeAndSplit.htm or
https://www.gmayor.com/individual_merge_letters.htm. with only a minor change you could run the macro from the process on the fly: Code:
Sub FixTable(oDoc As Document)
'Graham Mayor - https://www.gmayor.com - Last updated - 06 Nov 2020
Dim oTable As Table
Dim i As Integer, j As Integer
For j = oDoc.Tables.Count To 1 Step -1
Set oTable = oDoc.Tables(j)
For i = oTable.Rows.Count To 1 Step -1
oTable.Rows(i).Select
If Len(oTable.Rows(i).Range) <= 6 Then
oTable.Rows(i).Delete
End If
Next i
If oTable.Rows.Last.Cells.Count = 4 Then
oTable.Rows.Last.Delete
End If
Next j
Set oTable = Nothing
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
#2
|
|||
|
|||
|
The last thing I’ve been trying to do with this mailmerge is to do a conditional format in cells that contain certain words eg.
Good= Light green Very good = dark green Poor = yellow Bad = orange Very bad = red Please would it be possible to show me how to do this. Many thanks |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to remove almost a full page of blank space in between Word table rows
|
garrisonsdad | Word Tables | 4 | 10-18-2018 09:09 PM |
Remove blank table rows AFTER mailmerge
|
Formd | Mail Merge | 5 | 05-11-2018 03:43 PM |
How to remove blank spaces between rows in a table,
|
Jamal NUMAN | Word | 2 | 04-28-2017 12:59 PM |
| Remove any pivot table fields with a blank entry | Ramtrap | Excel Programming | 0 | 04-14-2017 07:00 AM |
| how to remove blank box on top-left corner of table in PPT 2010? | dylansmith | PowerPoint | 3 | 10-18-2012 03:59 AM |