How to export specific emails to excel?

[Prabhat Handoo]

I am stuck at a problem where I want to export emails with specific "TO"
( can be a Distribution List). And I expect the excel to have the email
address of the sender and the time at which the email was received. Is there
a way to do this? I have looked on several forums and sites, but unable to
find something like this.

My ultimate goal is to track the emails coming in my Microsoft outlook
sent to me Distribution List and export them in an excel sheet. The objective
is to look for the number of emails recieved and the time/date at which it
was received.. I am looking for the email sender and the time of the email
received to be exported in an excel format. I am aware about creating rules
and making sure that all the emails from the sender/DL to be placed in a
specific folder.

Note: I am using an IMAP account on my outlook and there is no exchange
server.

Any help is great appreciated!

 

[Roger Govier]

Hi Joel

this looked fascinating, so I loaded the code to try out for myself.
However, when attempting to run the macro, it stops immediately on the line
Private m_sch As Outlook.Search

with the error message

Compile error
User defined type not defined

Have you any idea as to what I may be doing wrong?

 

[Andy Pope]

Hi Roger,

Did you set a reference to the Outlook library, via VBE menu Tools >
References?

Cheers
Andy

 

[Dee S]

Hi Prabhat,

you may visit the following link. probably it might prove to be of some help to you.

http://www.techrepublic.com/blog/msoffice/quickly-export-outlook-e-mail-items-to-excel/744

Regards,
D