MailMergeDataSource Object
Description
Represents the mail merge data source in a mail merge operation.
Using the MailMergeDataSource Object
Use the DataSource property to return the MailMergeDataSource object. The following example displays the name of the data source associated with to the active document.
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.
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."
With Documents("Form letter.doc").MailMerge
.EditDataSource
If .DataSource.FindRecord(FindText:="Kate", Field:="FirstName") = True Then
MsgBox "Data was found"
End If
End With
Properties
ActiveRecord property, Application property, ConnectString property, Creator property, DataFields property, FieldNames property, FirstRecord property, HeaderSourceName property, HeaderSourceType property, LastRecord property, Name property, Parent property, QueryString property, Type property.
Methods
FindRecord method.