viktoryeung
New Member
- Joined
- Feb 6, 2005
- Messages
- 17
Hi,
Can Excel 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 Excel code so far. (which is PRETTY COOL if you wanna try it)
Can Excel 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 Excel code so far. (which is PRETTY COOL if you wanna try it)
Code:
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