MailMergeDataSource.FindRecord method (Publisher)

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.

Syntax

expression.FindRecord (FindText, Field)

expression A variable that represents a MailMergeDataSource object.

Parameters

Name	Required/Optional	Data type	Description
FindText	Required	String	The text to look for.
Field	Optional	String	The name of the field to be searched.

Return value

Boolean

Example

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.