This documentation is archived and is not being maintained.

MailMergeDataSource Object

Office 2007
Represents the data source in a mail merge or catalog merge operation.

Example

Use the DataSource property to return the MailMergeDataSource object. The following example displays the name of the data source associated with the active publication.

Visual Basic for Applications
Sub ShowDataSourceName()
    If ActiveDocument.MailMerge.DataSource.Name <> "" Then _
        MsgBox ActiveDocument.MailMerge.DataSource.Name
End Sub

The following example tests the open data source associated with the active publication to determine whether the LastName field includes the name Fuller.

Visual Basic for Applications
Sub FindSelectedRecord()
    With ActiveDocument.MailMerge
        If .DataSource.FindRecord(FindText:="Fuller", _
                Field:="LastName") = True Then
            MsgBox "Data was found"
        End If
    End With
End Sub



Show: