Macro: Get Email Address from CC field (Outllok email msg)

hi all,

i found below macro from this site. what is does is downloads data from emails in outlook inbox.

Please Login or Register  to view this content.

after googling out, i can get the sender email address by adding this line

Please Login or Register  to view this content.

but i cannot get email address from CC field. i add this line

Please Login or Register  to view this content.

but didn't work. it only gets the Name of the recipient. (i.e it only gets "Jonah" out of "Jonah" <[email protected]>)

how can i get the complete email address from CC field?

update..

i manage to move 1 step forward after seeing this discussion.
by trial / error, i ended up with this code

Please Login or Register  to view this content.

if only one email message in the selected outlook folder, than the code can be considered working as hope. Problem come when more than one email messages in the selected outlook folder. The code is getting all recipients from each email message and COMBINE all the recipients.

Let me picture it this way.

OUTLOOK FOLDER (SPAMFOLD)

-- EMAIL MSG1 (has 20 recipients)
-- EMAIL MSG2 (has 3 recipients)
-- EMAIL MSG3 (has 12 recipients)

in excel activesheet, the code will

> take recipients emailaddr from EMAIL MSG1 and put it on 2nd row of column "C"
> take recipients emailaddr from EMAIL MSG1 + EMAIL MSG2 and put it on 3rd row of column "C"
> take recipients emailaddr from EMAIL MSG1 + EMAIL MSG2 + EMAIL MSG3 and put it on 4th row of column "C"

The recipients from first email (EMAIL MSG1) is ok, but the second and third emails (EMAIL MSG2 and EMAIL MSG3) is NOT ok, since they are resulted from combination.

I am hoping to have the recipients on PER EMAIL MESSAGE basis, not a combination.

can someone please help, this is really frustating. been googling for 2 days but cannot find any solution.

thanks