Extract Outlook to Excel based on formatting

[StevieV]

Hi,

I am working on a macro to export outlook body text to excel. I understand how to extract elements from the Outlook body but is there a way to only extract body elements which are formatted as bold text?

Thanks
S

 

[XLfriend777]

Hi StevieV - As nobody has responded I thought I would try to help get you started. I'm not sure if this will work in Outlook, but I have successfully used the code below to search for Bold text in Excel.

Sub BoldSelect()
i = 1
While Cells(i, 1) <> ""
Cells(i, 1).Select
        If Selection.Font.Bold = True Then
        MsgBox "Found Bold"
        End If
i = i + 1
Wend
End Sub

Hope this helps.