VBA Code to find a record in the MS word mail merge
MS Word mail merge has an option to navigate through the records. The below VBA code will help you to type and search the record within the MS word document area, you do not have to go to the menu bar. 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. With ActiveDocument.MailMerge .DataSource.ActiveRecord = wdFirstRecord End With 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 End If End Sub Watch the complete step by step tutorial Download the Excel file and the word docum...