Avatar of Chuck Hughes
Chuck Hughes
 asked on

Extract data from Outlook

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
OutlookMicrosoft Access

Avatar of undefined
Last Comment
John

8/22/2022 - Mon
John

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.
PatHartman

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.
ImportMailFromOutlook.docx
Alexei Kuznetsov

@John: this is the easiest way, but unfortunately Outlook can't export Received, Has Attachments, Created and Modified fields to CSV =(
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Chuck Hughes

ASKER
Pat,
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.


Chuck
Gustav Brock

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.

/gustav
Chuck Hughes

ASKER
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.  


Chuck
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Gustav Brock

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
John

Can you please come back and close the question?