Data: Export Email to Excel

Reference: https://support.office.com/en-us/article/back-up-your-email-e5845b0b-1aeb-424f-924c-aa1c33b18833

Steps:

  • open Outlook
  • Move the emails that you want to export to a folder
  • Go to the folder
  • File -> Open & Export -> Import and Export
  • Choose an action to perform: ->Export to a file -> Next
  • Create a file of type: -> Comma Separated Values
  • Select folder to export from: (The folder that you were in are highlighted) -> Next
  • Save exported file as: -> Browse -> select folder and create file name -> Next
  • The following actions will be performed: Export “Email messages” from folder: xxxxxxxx -> Map Custom Fields -> Finish
    • Subject
    • Body
    • From: (Name)
    • From: (Address)
    • From: (Type)
    • To: (Name)
    • To: (Address)
    • To: (Type)
    • BCC: (Name)
    • BCC: (Address)
    • BillingInformation
    • Categories
    • Importance
    • Mileage
    • Sensitivity