MailMerge object (Word)
Represents the mail merge functionality in Word.
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 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.