Export Outlook e-mails to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nico - 28 May 2008 16:03 GMT

Is this possible?

Right now I've got it set to export to text, which works fine, but I'm
having difficulty transferring this to Excel. I've got it to capture the
sender and date/time, but not the receiver or subject.

All I want to capture is the sender, date/time sent, receiver and subject
and have this appear in Excel, somehow.

Thanks!

Reply to this Message

elegaultZZZ@REMOVEZZZmvps.org - 28 May 2008 17:52 GMT

An easy trick to get Outlook e-mail data into Excel is to create a View in a
folder that contains all the columns you want - then just select all - or
just the desired messages - and paste it right into Excel.

For some issues with multi-line fields, see my blog:

Eric Legault My Eggo : If the columns and rows are messed up when copying
items to Excel from an Outlook view...:
http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

Signature

Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
Collaborative Innovations
-> Try Picture Attachments Wizard For Microsoft Outlook <-
Web: http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault

> Is this possible?
>
[quoted text clipped - 6 lines]
>
> Thanks!

Reply to this Message

Nico - 28 May 2008 20:46 GMT

Thanks, but I need to automate this as we're using it to log response times
to e-mails to track our SLAs.

If I can export to Excel I can then import to Access and we can easily query
and report on these.

Any ideas?

Thanks!

> An easy trick to get Outlook e-mail data into Excel is to create a View in a
> folder that contains all the columns you want - then just select all - or
[quoted text clipped - 16 lines]
> >
> > Thanks!

Reply to this Message

JP - 28 May 2008 21:10 GMT

Does this help?

http://support.microsoft.com/kb/290792

--JP

> Thanks, but I need to automate this as we're using it to log response times
> to e-mails to track our SLAs.
[quoted text clipped - 16 lines]
> > items to Excel from an Outlook view...:
> >http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

Reply to this Message