Extracting CC Email Address Using VBA

E

ejek6337

Hello,

I have the current code that works for extracting various information from
the MailItem Object:

If itm.Class = olMail Then
Set msg = itm
objWks.Cells(i + 1, 1) = msg.Subject
objWks.Cells(i + 1, 2) = msg.ReceivedTime
objWks.Cells(i + 1, 3) = msg.SenderName
objWks.Cells(i + 1, 4) = msg.SenderEmailAddress
objWks.Cells(i + 1, 5) = msg.Body
objWks.Cells(i + 1, 21) = msg.CC
objWks.Cells(i + 1, 22) = msg.To

It is dumpting the data into an excel spreadsheet. I am able to extract the
sender email address with "SenderEmailAddress". Is there any possible way to
extract all the CC Email Addresses as well? The "CC" above only extracts the
name(s) in the field, not the actual email address. If there is not way to
do it I don't want to waste my time researching further. Thank you for any
information you can provide.

Ed
 
M

Michael Bauer [MVP - Outlook]

See the Recipients collection, and check the type property of each recipient
object.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Fri, 20 Nov 2009 12:14:01 -0800 schrieb ejek6337:
 
E

ejek6337

Thanks a million. The recipients object worked like a charm. I knew I was
just overlooking something. Thanks for the direction.

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top