Need a Macro to Copy E-Mail(outlook) subject Line to Excel

[naven_sg]

Hello All,

I have around 7000 mails (outlook) in folder, these are in *.msg format. I need a Macro to open these mails and copy the "Subject" and "Sent" information to an excel sheet. I use 2007 version of outlook.

Can you please help me....!!!

Regards,
NG

 

[stolie]

You might want to see if there is an export function within Outlook that can do this for you.

 

[naven_sg]

Hello,

Thanks for that information. The "Export" Function does not exports the mail "Received Date" information. It only exports Subject line, To, CC, BCC information & Body of the mail.

Is there any way i can get the this "Receive Date" information also.

Thanks,
Ng

 

[Marc]

I recently cobbled the code on this post to do the same thing:

http://www.mrexcel.com/forum/showth...look.MAPIFolder,+Collection+As+Outlook.Items)

However, I'm not so sure you can pull the "Receive Date" information, but the "Sent On" date is available.