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
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