MailMerge Object

Document MailMerge Multiple objects

Represents the mail merge functionality in Word.

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 operation has begun. Use the State property to determine the status of the mail merge operation. The following example executes a mail merge if the active document is a main document with an attached data source.

If ActiveDocument.MailMerge.State = wdMainAndDataSource Then
    ActiveDocument.MailMerge.Execute
End If

The following example merges the main document with the first three data records in the attached data source and then sends the results to the printer.

Set myMerge = ActiveDocument.MailMerge
If myMerge.State = wdMainAndSourceAndHeader Or _
    myMerge.State = wdMainAndDataSource Then
    With myMerge.DataSource
        .FirstRecord = 1
        .LastRecord = 3
    End With
End If
With myMerge
    .Destination = wdSendToPrinter
    .Execute
End With

Properties | Application Property | Creator Property | DataSource Property | Destination Property | Fields Property | HighlightMergeFields Property | MailAddressFieldName Property | MailAsAttachment Property | MailFormat Property | MailSubject Property | MainDocumentType Property | Parent Property | ShowSendToCustom Property | State Property | SuppressBlankLines Property | ViewMailMergeFieldCodes Property | WizardState Property

Methods | Check Method | CreateDataSource Method | CreateHeaderSource Method | EditDataSource Method | EditHeaderSource Method | EditMainDocument Method | Execute Method | OpenDataSource Method | OpenHeaderSource Method | ShowWizard Method

Parent Objects | Document Object

Child Objects | MailMergeDataSource Object | MailMergeFields Object

See Also | MailMergeDataSource Object | MailMergeField Object | MailMergeFields Collection Object