Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2008
    Posts
    73
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Exporting Outlook email details

    Is there any way to export the details in excel of the outlook emails sent to a particular sender in a specified date and time interval?

    Details required are:-

    Count of Emails (Only initial emails - No replies and forwarded messages)
    Subject line of all the emails
    From
    TO




    Any help would be highly appreciated

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    New Lounger Ensemble's Avatar
    Join Date
    Apr 2013
    Location
    Centurion
    Posts
    23
    Thanks
    9
    Thanked 1 Time in 1 Post
    Exporting would be slightly different depending on what version of outlook you use:

    Using Outlook 2010:

    go <File>, <Options>, <Advanced>, <Export>

    Follow the wizzard steps, selecting your folder.

    This will export all the mails in the folder to excell. The following fields are exported:

    Subject
    Body
    FromName
    FromAddress
    FromType
    ToName
    ToAddress
    ToType
    CCName
    CCAddress
    CCType
    BCCName
    BCCAddress
    BCCType
    BillingInformation
    Categories
    Importance
    Mileage
    Sensitivity


    In excel you can incert a column to the right of the "Subject" column and enter a formula

    =LEFT(A2,2)

    into cell B2, copy this cell and past it in all the lines in B column (inserted column).

    Now you can filter the worksheet to exclude "RE" and "FW" in the B column and include only the required sender in the "FromName" column and your required date range as well.

    This is the long way to do, I am sure there is a shorter way, hope somebody can enlighten us.


    Ensemble





    WHY?

  4. #3
    New Lounger Ensemble's Avatar
    Join Date
    Apr 2013
    Location
    Centurion
    Posts
    23
    Thanks
    9
    Thanked 1 Time in 1 Post
    PS: Should you want to use other mail fields than those listed above, you have to use MS Access and not Excel.

    Ensemble

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •