INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

Join Us!

*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

Tek-Tips Posting Policies

Home > Forums > MIS/IT > Office Suites > Microsoft: Office > FAQs

Microsoft: Office FAQ

Word Mail Merge

How to MAIL MERGE and PRINT each Recipient Separately by SkipVought

faq68-6655

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

My FAQ Archive

Contact US