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. #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?

  3. #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
  •