Export Outlook e-mails to Excel

  • Thread starter Thread starter Nico
  • Start date Start date
N

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

[email protected] said:
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 said:
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!
Click to expand...
Click to expand...
 
Back
Top