Skip to content

Instantly share code, notes, and snippets.

Avatar

alanreeves001

View GitHub Profile
@alanreeves001
alanreeves001 / Microsoft Word - Mail merge - Save or print entries separately
Last active Dec 27, 2015
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.
View Microsoft Word - Mail merge - Save or print entries separately
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