Table of contents
Collapse the table of content
Expand the table of content

MailMergeDataSource.FindRecord Method (Publisher)

office 365 dev account|Last Updated: 8/24/2017
3 Contributors

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


expression. FindRecord( FindText, Field)

_expression_A variable that represents a MailMergeDataSource object.


NameRequired/OptionalData TypeDescription
FindTextRequiredStringThe text to look for.
FieldOptionalStringThe name of the field to be searched.

Return Value



This example displays a merge publication for the first record in which the FirstName field contains Joe. If the record is found, the record number is stored in a variable.

Sub FindDataSourceRecord() 
 Dim dsMain As MailMergeDataSource 
 Dim intRecord As Integer 

 'Makes the data in the data source records instead of the field codes 
 ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False 

 Set dsMain = ActiveDocument.MailMerge.DataSource 

 If dsMain.FindRecord(FindText:="Joe", _ 
 Field:="FirstName") = True Then 
 intRecord = dsMain.ActiveRecord 
 End If 

End Sub
© 2018 Microsoft