MailMergeDataSource.FindRecord procedure builder

MailMergeDataSource.FindRecord (Word)

Searches the contents of the specified mail merge data source for text in a particular field. Returns True if the search text is found.

This method corresponds to the Find Record button on the Mail Merge toolbar. The FindRecord method does a forward search only. Therefore, if the active record is not the first record in the data source and the record for which you are searching is before the active record, the FindRecord method will return no results. To ensure that the entire data source is searched, set the ActiveRecord property to wdFirstRecord.

FindRecord (FindText, Field)

Dim dsMain As MailMergeDataSource 
Dim numRecord As Integer 
ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False 
Set dsMain = ActiveDocument.MailMerge.DataSource 
If dsMain.FindRecord(FindText:="Joe", _ 
 Field:="FirstName") = True Then 
 numRecord = dsMain.ActiveRecord 
End If


The following argument is required

FindText (String) - The text to be looked for.

Optional arguments

The following argument is optional

Field - The name of the field to be searched