Exporting Outlook mail Subjects to table

Posted on 2014-07-14
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 ( 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 9

    Assisted Solution

    by:Clark Kent
    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:

    Clark Kent
    LVL 13

    Accepted Solution

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    755 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

    20 Experts available now in Live!

    Get 1:1 Help Now