Skip to content

Instantly share code, notes, and snippets.

View alanreeves001's full-sized avatar

alanreeves001

View GitHub Profile
@alanreeves001
alanreeves001 / Microsoft Word - Mail merge - Save or print entries separately
Last active December 27, 2015 23:09
Macro for Microsoft Word (written in Visual Basic) that will save or print each entry in a mail merge. It was created to be used when printing a newsletter that required printing, folding, and stapling. Unless each entry for the mail merge was printed separately, the printer tried to fold and staple several newsletters at once.
Sub PrintMailMergeSeparately()
'
' PringMailMergeSeparately Macro
' - This macro prints each mail merge as an individual document to aid in folding and stapling
'
Dim lname As String
Dim totalMailings As Long
Dim i As Integer
totalMailings = ActiveDocument.MailMerge.DataSource.RecordCount