This example displays a merge document for the first data record in which the FirstName field contains "Joe." If the data record is found, the number of the record is stored in the numRecord
variable.
ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False
Set myMMData = ActiveDocument.MailMerge.DataSource
If myMMData.FindRecord(FindText:="Joe", _
Field:="FirstName") = True Then
numRecord = myMMData.ActiveRecord
End If