MailMerge Object

Microsoft Publisher Visual Basic

Show All Show All

MailMerge Object

Document MailMerge
MailMergeDataSource

Represents the mail merge and catalog merge functionality in Publisher.

Using the MailMerge Object

Use the MailMerge property to return the MailMerge object. The MailMerge object is always available regardless of whether the mail merge or catalog merge operation has begun. The following example merges and prints the main publication with the first three data records in the attached data source.

Sub SelectiveMerge()
    Dim mrgMain As MailMerge
    Set mrgMain = ActiveDocument.MailMerge
    With mrgMain.DataSource
        .FirstRecord = 1
        .LastRecord = 3
    End With
    mrgMain.Execute True
End Sub