I am using the below macro to search a document to find a ticker that I type into an input box from an excel document and use it to populate a report based on the horizontal data that corresponds to the mail merge fields in word. I am using the below macro - which for the most part works perfectly. However, if I type in a ticker with less than 4 characters it produces the first instance in the list that includes the letters in the input box. For example, if I type in AM it returns AKAM which appears first in the list. I want to be able to type in AM and get AM. Help!
Sub Macro()
Dim numRecord As Integer
Dim Ticker As String
Ticker = InputBox("Enter the Ticker:")
Set dsMain = ActiveDocument.MailMerge.DataSource
If dsMain.FindRecord(FindText:=Ticker, Field:="Ticker") = True Then
numRecord = dsMain.ActiveRecord
End If
End Sub