troubleshooting Question

[Outlook VBA] Find text in selection with regex and format

Avatar of Thomas PAIK
Thomas PAIK asked on
Regular ExpressionsOutlook
3 Comments1 Solution49 ViewsLast Modified:
Help would be appreciated (please provide code if possible)!

1. Select part of the Outlook mail body with the mouse
2. Run the macro on the selection

[Current outcome]
12-12-12 (bold)

[Desired outcome]
12-12-12 (bold)
1234-1234-1234 (bold)
12-1234-12 (bold)
1234-12-12 (bold)

[VBA code]
Sub SetFoundText2Bold()
    Dim objItem As Object
    Set objItem = Application.ActiveInspector.CurrentItem
    Dim objInsp As Outlook.Inspector
    Set objInsp = objItem.GetInspector
    Dim objDoc As Word.Document
    Set objDoc = objInsp.WordEditor
    Dim objWord As Word.Application
    Set objWord = objDoc.Application
    Dim objSelect As Word.Selection
    Set objSelect = objWord.Selection
    Dim objRegExp As RegExp
    Set objRegExp = New RegExp
    Dim objMatches As MatchCollection
    Dim objMatch As Variant
    With objRegExp
        .MultiLine = True
        .Global = True
        .IgnoreCase = True
        .Pattern = "\d{2,4}-\d{2,4}-\d{2,4}"
    End With
    If (objRegExp.Test(objSelect.Text) = True) Then
        Set objMatches = objRegExp.Execute(objSelect.Text)   ' Execute search
        For Each objMatch In objMatches
            With objSelect.Find
                .Text = objMatch
                .Replacement.Font.Bold = True
                .Execute Replace:=wdReplaceOne
            End With
    End If
End Sub
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros