Exporting Outlook mail Subjects to table

Posted on 2014-07-14
Medium Priority
Last Modified: 2014-07-17

I have a requirement where I need to save the email subject lines to sql table?

Is it possible to copy mails (subject line) only from specific address (name@example.com) instead just inbox?
I assume this can achieved using C# but  I do not have knowledge on .NET technology. I'm BI guy
How difficult is this requirement?
Thanks in advance
Question by:parpaa
LVL 11

Assisted Solution

by:Clark Kent
Clark Kent earned 1000 total points
ID: 40196256
Hi parpaa,

Yes, Outlook provides an feature named “Filter” through you can apply a criteria to export emails according their subject, filed, etc.

Filter option in Outlook while exporting the data
For more about Filter in MS-Outlook: http://www.msoutlook.info/question/649

Clark Kent
LVL 15

Accepted Solution

Alexei Kuznetsov (Outlook MVP) earned 1000 total points
ID: 40202499
To export subjects from all your mailbox you can do the following:

1. Create Search Folder

Just right-click Search Folders and select New Search Folder....Choose Mail from specific people and select the required address. You can also Create a custom Search Filter if needed.

2. Export Subjects

Open the newly create search folder, now you have a list of all emails from the specified address. To export subjects only you can use the free Save One Field Value utility. Just specify target text file and type Subject as a field name.

3. Import to SQL

There are many ways to import plain text file to the SQL database. You can use any suitable for you.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
Suggested Courses

862 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