Microsoft Office Forums - View Single Post - [Solved] Blank Lines in Mail Merge

macropod · 12-05-2019, 01:25 PM

You aren't suppressing/removing lines - those are table rows. The problem can be addressed by adding the following macro to your mailmerge main document (which you'll need to save in the .docm format):

Code:

Sub MailMergeToDoc()
Application.ScreenUpdating = False
Dim Tbl As Table, r As Long
ActiveDocument.MailMerge.Execute
With ActiveDocument
  For Each Tbl In .Tables
    With Tbl
      For r = .Rows.Count To 8 Step -1
        With .Rows(r)
          If Len(.Cells(2).Range.Text) = 2 Then .Delete
        End With
      Next
    End With
  Next
End With
Application.ScreenUpdating = False
End Sub

Now, when you click on Finish & Merge>Edit Individual Documents, the macro will automatically delete all table rows from the output where the second cell in the row is empty.

For PC macro installation & usage instructions, see: Installing Macros
For Mac macro installation & usage instructions, see: Word:mac - Install a Macro