×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft: Office FAQ

Word Mail Merge

How to MAIL MERGE and PRINT each Recipient Separately by SkipVought
Posted: 25 May 07 (Edited 25 May 07)

You already have your Mail Merge document configured with a valid Data Source.  Now you want to print each recipient separately.

Here's the concept, for purposes of understanding how it's done:
The View Merged Data button on the Mail Merge Toolbar, toggles the MergeFields to display the DATA or the FIELD NAME. You want to display the DATA.

You have the first record's data displayed in your document.

Now hit the Next Record button on the Mail Merge Toolbar.

You have the second record's data displayed in your document.  Get the picture?

Here's all you have to do:


DO NOT PERFORM THE MAIL MERGE YOURSELF.
  This code does the merge record by record.

Copy this code and paste into the ThisDocument code window.  alt+F11 toggles between the document and the VB Editor.

Tools>Macro>Macros - Select PrintEachRecipient and RUN

CODE

Sub PrintEachRecipient()
    Dim i As Integer
'
    With ActiveDocument.MailMerge
        'SHOW ME THE DATA, rather than the merge codes
        .ViewMailMergeFieldCodes = False

        For i = 1 To .DataSource.RecordCount
            ActiveDocument.PrintOut
            .DataSource.ActiveRecord = wdNextRecord
        Next
    End With
End Sub

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close