Export Outlook e-mails to Excel

[Nico]

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!

 

[Guest]

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

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

 

[Nico]

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

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

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!

 

[JP]

Does this help?

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


--JP