View Single Post
 
Old 04-06-2016, 05:46 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,526
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There's still no attachment, but you might try running the following macro on your mailmerge output document:
Code:
Sub Reformat()
Application.ScreenUpdating = False
Dim HdFt As HeaderFooter, Rng As Range
With ActiveDocument
  If .Sections.Count > 1 Then
    For Each HdFt In .Sections(.Sections.Count).Headers
      If HdFt.Exists Then
        HdFt.Range.FormattedText = .Sections(1).Headers(HdFt.Index).Range.FormattedText
        HdFt.Range.Characters.Last.Delete
      End If
    Next
    For Each HdFt In .Sections(.Sections.Count).Footers
      If HdFt.Exists Then
        HdFt.Range.FormattedText = .Sections(1).Footers(HdFt.Index).Range.FormattedText
        HdFt.Range.Characters.Last.Delete
      End If
    Next
  End If
  Do While .Sections.Count > 1
    Set Rng = .Sections(1).Range.Characters.Last
    Rng.Delete
    Rng.InsertBreak Type:=wdPageBreak
    DoEvents
  Loop
  .Range.Characters.Last.Delete
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote