Can I export my Outlook inbox as an Excel list?

K

Kristen

My company creates reports based on e-mail input. I'd like to export the
names, dates, subjects from my inbox into Excel to parse/manipulate the info.
We currently print the entire (2000+) inbox as a table and do several manual
counts using colored map pencils--it takes hours!!! Thanks.
 
F

F.H. Muffman

My company creates reports based on e-mail input. I'd like to export the
names, dates, subjects from my inbox into Excel to parse/manipulate the info.
We currently print the entire (2000+) inbox as a table and do several manual
counts using colored map pencils--it takes hours!!! Thanks.

Get the view the way you want it in Outlook (ie, all the data shown that
you want), select all the items, hit control-c, then control-v into a spreadsheet.
You may need to build your own custom view and customize the Date column
to show full dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top