Sunday, September 30, 2018

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 document from this link below

Download

9 comments:

  1. Thanks for sharing these niche piece of info's to our knowledge. Here, I had a solution for my inconclusive problems & it’s really helps me a lot keep updates…
    Ethical Hacking Course in Chennai
    Hacking Course in Chennai
    Angularjs Training in Chennai
    CCNA Training in Chennai
    Salesforce Training in Chennai
    Ethical Hacking Course in Chennai
    Hacking Course in Chennai

    ReplyDelete
  2. that that move goes. It might be just submitted on well known talking about destinations like YouTube, Facebook, MetCafe. word converter online

    ReplyDelete
  3. There is definately a great deal to find out about this topic. I like all the points you have made.

    Click here to get More information.

    ReplyDelete
  4. You ought to be a part of a contest for one of the finest websites on works the net. I am going to highly recommend this blog!

    ReplyDelete
  5. Spot on with this write-up, I truely take delivery of as authentic with that this wonderful internet website online goals an lousy lot extra interest. I’ll probable be returning to net info study thru greater, thanks for the statistics!

    ReplyDelete

Looking to move from development to DevOps? Here is what you should know

DevOps is a buzz word in the last decade, everybody wants to try their luck in DevOps. DevOps is the most generic area of software engineeri...