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
Chuck HughesAsked:
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.

JohnBusiness Consultant (Owner)Commented:
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.
0
PatHartmanCommented:
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
1
Alexei KuznetsovMicrosoft Outlook MVPCommented:
@John: this is the easiest way, but unfortunately Outlook can't export Received, Has Attachments, Created and Modified fields to CSV =(
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Chuck HughesAuthor Commented:
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
0
Gustav BrockCIOCommented:
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
0
Chuck HughesAuthor Commented:
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
0
Gustav BrockCIOCommented:
You would link to one user and one folder only for each table. Once linked, there is no wizard to run, just open the table (or a form bound to it).

If it is only to retain data, set up automatic forwarding to another account or an external service. For key personel, we forward everything from our Office 365 (Exchange) accounts to a collection of free accounts at Outlook.com for this very purpose.

/gustav
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
JohnBusiness Consultant (Owner)Commented:
Can you please come back and close the question?
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.