How to extract / scrape / compile every email within Outlook?

Posted on 2012-08-27
Last Modified: 2012-09-04
Hello all, I have over 50,000 emails in my Outlook 2010. Email is provided through a hosted Exchange provider. What I am trying to do is extract/scrape every single email that has every been indexed in my email and then compile that into some kind of contact list (perhaps in Excel). How can I do this?

I have Excel 2010 but can use any version that's necessary.

Any help would be appreciated.
Question by:XAnalyzer
    LVL 33

    Expert Comment

    What data do you want to compile from the emails?

    Author Comment

    Just the email addresses. The goal is to compile all my contats so that I can send them an email about my new contact information.

    Author Comment

    I just want to get a list of all the contacts I've ever communicated with so that I can send an email to each and every one of them with my new company contact information.
    LVL 47

    Accepted Solution

    Thats pretty easy then

    Simply Open Outlook
    Go to File>Open>Import

    Select Export to File
    Select Comma Spereated Values (Windows)
    In the Next window choose your folder with the Emails

    In the next window Name your CSV and specify its location
    (Local Ideal for Large Exports, i.e. C:Drive )

    Then NExt

    All the emails will be eported into an Excel CSV File

    Once done open it  up

    In Column D  (May Vary)
    You should see
    From: (Address)

    This will be the email addresses of all the emails sent to you
    LVL 47

    Expert Comment

    Note you can also do the same for sent items, for a comprehensive list

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    Use email signature images to promote corporate certifications and industry awards.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now