Outlook 2007 reports

I need a report of all sent items. How do I include the date, time, subject and To fields.
oandosupportAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian GeeCommented:
Will printing your Sent Items folder in Table Style (with the Fields you specified) not accomplish this objective? Or is there something more you're looking for with regard to such reports?
0
oandosupportAuthor Commented:
yes, but how do i export to excel?
0
Brian GeeCommented:
So this is to viewed in Excel... in order to get output that includes date and time information, you'll need to have the Sent Items folder in Outlook exported. Doing so with Excel will not include the date and time information though. Launch MS Access (providing you have it), and then go to File > Get External DataImport > select Exchange() from the Files of Type dropdown at the bottom > expand the Mailbox in question > and then choose the Sent Items folder.

You'll end up getting more information than you'll need this way, but from here, you can either use Access to query the fields you need to a new table, or you can save the Access table output into Excel and then delete the columns you don't need accordingly.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
oandosupportAuthor Commented:
Great stuff.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.