Exchange – extracting email properties

5 pts.
Tags:
Microsoft Exchange 2007
SQL Server tables
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account - I don't want the content of the emails - but what I want is emailID, subjsy, date received and it's current location (ie what folder is it in) in that email account. I need this data extract to a CSV or better still - can I pump it directly into a SQL Server table? Thanks

Software/Hardware used:
exchange 2007 / office 2010

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Amanda lakai
    Follow the given steps to export email addresses from Outlook 2010 emails: 1.Move or copy all the emails(from which you want to extract email addresses) into a folder. 2.Go to the Outlook File tab then, click Options. 3.Choose “Advanced” from the Options dialog box . 4.Click “Export” from the Export section on the right. 5.Then, select “Export to a file” and click Next. 6.Choose “Comma Separated Values(Windows)” and click Next. 7.Select the folder containing your emails and click Next. 8.Choose a location to save the spreadsheet and click Next. 9.Click the “Map custom fields” button. 10.Choose the desired fields to be exported. 11.Click finish.
    1,475 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following