This code first resets the document to the first record. This is required as the mail merge navigation is only forward. That means the VBA code cannot traverse backward.
Reads a text from TextBox which is placed within the document. If the keyword entered and the current record is matched, then the Active document is activated with the current record.
.DataSource.ActiveRecord = wdFirstRecord
Dim numRecord As Integer
Dim searchText As String
searchText = TextBox1.Text
Set dsMain = ActiveDocument.MailMerge.DataSource
If dsMain.FindRecord(FindText:=searchText, Field:="Name") = True Then
numRecord = dsMain.ActiveRecord
Watch the complete step by step tutorial
Download the Excel file and the word document from this link below