Share via

MailMergeDataSource Object

  • Article
Word Developer Reference

Represents the mail merge data source in a mail merge operation.

Remarks

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

Visual Basic for Applications 
  If ActiveDocument.MailMerge.DataSource.Name <> "" Then _
    MsgBox ActiveDocument.MailMerge.DataSource.Name

The following example displays the field names in the data source associated with the active document.

Visual Basic for Applications 
  For Each aField In ActiveDocument.MailMerge.DataSource.FieldNames
    MsgBox aField.Name
Next aField

The following example opens the data source associated with Form letter.doc and determines whether the FirstName field includes the name "Kate."

Visual Basic for Applications 
  With Documents("Form letter.doc").MailMerge
    .EditDataSource
    If .DataSource.FindRecord(FindText:="Kate", _
            Field:="FirstName") = True Then
        MsgBox "Data was found"
    End If
End With

See Also