We help IT Professionals succeed at work.

Extract data from Outlook

Chuck Hughes
Chuck Hughes asked
Last Modified: 2017-11-05
Need to extract a email when it comes into my email from selected users and export data to access database.

Outlook 2013
Access 2013

Database: Work Search Progress
Table Name: Emails
Table Structure: ID
Subject - Short Text
From - Short Text
Senders Name - Short Text
Received - Date/Time
Contents - Long Text
Has Attachments - Yes/No
Created - Date/Time
Modified - Date/Time
Watch Question

JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Outlook has a proprietary database. A good way to do this is to export the Outlook data to Excel (Native to Outlook - Outlook, File, Open and Export) and then import the Excel File to Access.
Distinguished Expert 2017

Unless you are comfortable with creating macros/VBA in Outlook, you can't intercept the email as it arrives.  To do this from Access, you need to periodically start a process to read your email folders (it would help if you can create a rule that puts the emails you are interested in into a special folder).  You can then download the attachments or parse the email string and save the data to Access.  Your procedure should then copy the email to a "completed" folder and delete it from the original folder.  That way, only unprocessed emails exist in the input folder.

I attached a Word document with the contents of a link that I think might get you started.  I included the URL in the document.  This site does not want links to competing sites so I attached what you need.

If that doesn't cover what you need, we'll need more information.
Alexei KuznetsovMicrosoft Outlook MVP

@John: this is the easiest way, but unfortunately Outlook can't export Received, Has Attachments, Created and Modified fields to CSV =(


I can create vb script in Outlook if I have guidance. And as far as the attachment it's not a big deal not to have it.

Most Valuable Expert 2015
Distinguished Expert 2018

The clean method is to open Access:

- go to External Data
- select More, Outlook Folder

The External Data window opens.

- select option three: Create a link to the data source ... click OK
- follow the guide/wizard to link the Outlook folder of your choice.

When finished, the linked table will hold all the fields you list.



Thanks Gustav,
But I'm looking at exporting it from outlook when it arrives so it doesn't get deleted or something. If I have to wait and go and open Access and run the import wizard I might have missed something. Also I'm looking to export only certain users and data.  

Most Valuable Expert 2015
Distinguished Expert 2018
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Can you please come back and close the question?

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions