Thread: MS Outlook Social connector (grab pictures)

Hi,
Can VBA grab the profile pics from MS Outlook Social connector?
My Excel macro is hacking the Outlook sent folder and importing recipient email address into a worksheet. I want to grab the recipient profile picture too.

Here is my code so far.

Sub ImportOutlook()
Dim nms As Outlook.Namespace
Dim fld As Outlook.MAPIFolder
Dim msg As Outlook.MailItem
Dim recip As Outlook.Recipient
Dim itm As Object
Dim numrow As Integer

Set nms = GetNamespace("MAPI")
Set fld = nms.GetDefaultFolder(olFolderSentMail)

'COPY FIELDS INTO EXCEL COLUMNS
For Each itm In fld.Items
    numrow = numrow + 1
    Set msg = itm
    
    For Each recip In msg.Recipients
        Cells(numrow, 1).Value = recip.Address    'COLUMN A
    Next
    Cells(numrow, 2).Value = msg.Subject          'COLUMN B
    Cells(numrow, 3).Value = msg.SentOn           'COLUMN C
    'Cells(numrow, 4).Value = ?????  (insert profile picture from MS Outlook Social Connector)
Next itm
End sub