![]() |
|
#34
|
||||
|
||||
|
Try:
Code:
Sub MailMergeToDoc()
Application.ScreenUpdating = False
Dim t As Long, r As Long, bDel As Boolean
ActiveDocument.MailMerge.Execute
With ActiveDocument
For t = .Tables.Count To 1 Step -1
With .Tables(t)
If Split(.Cell(1, 1).Range.Text, vbCr)(0) Like "#### Awards (Vesting ####)" Then
bDel = True
For r = .Rows.Count - 1 To 2 Step -1
If Trim(Split(.Cell(r, 1).Range.Text, vbCr)(0)) Like "[DPR][BS]P Award" Then
If Split(.Cell(r, 4).Range.Text, vbCr)(0) <> "" Then
bDel = False
Else
.Rows(r).Delete
End If
End If
Next
If bDel = True Then .Delete
End If
End With
Next
End With
Application.ScreenUpdating = False
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to delete every blank and non-numeric rows without removing the header | enuff | Excel | 3 | 08-24-2017 05:56 AM |
| Removing blank pages at the end of a document | Xanzia | Word | 3 | 06-01-2014 11:13 AM |
Getting blank lines instead of supressed lines.
|
Welshie82 | Mail Merge | 2 | 11-14-2011 01:41 AM |
| Urgent help needed with removing blank lines... | iammom2four | Outlook | 0 | 12-15-2010 06:12 AM |
How to turn all blank lines into non-blank for legal forms
|
sieler | Word | 3 | 04-12-2009 01:38 PM |