Share via

Export To a csv File exports x500 format address for To, CC & BCC fields in Outlook

Niranjan T Pattana Shetty 286 Reputation points
2022-04-08T05:16:36.94+00:00

Hi All,

Whenever I try to export mails from a folder in my Outlook to a csv file using the Export To a File option, the

To: (Address) , CC: (Address)

fields show up x500 format address values instead of regular SMTP, not sure what needs to be done to see SMTP, kindly help meBCC: (Address)

Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,072 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,069 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,503 questions
Microsoft Exchange Hybrid Management
Microsoft Exchange Hybrid Management
Microsoft Exchange: Microsoft messaging and collaboration software.Hybrid Management: Organizing, handling, directing or controlling hybrid deployments.
1,999 questions
Accepted answer
  1. Joyce Shen - MSFT 16,651 Reputation points
    2022-04-12T08:16:00.94+00:00

    Hi @Niranjan T Pattana Shetty

    Thanks for your feedback, Since our forum has the policy that The question author cannot accept their own answer. They can only accept answers by others, and according to the scenario introduced here: Answering your own questions on Microsoft Q&A

    I would make a brief summary of this post so that other forum members could easily find useful information here:

    [Export To a csv File exports x500 format address for To, CC & BCC fields in Outlook - Summary]

    Issue Symptom:
    When export mails from a folder in Outlook to a csv file using the Export To a File option, the To: (Address) , CC: (Address) fields show up x500 format address values instead of regular SMTP.

    (Possible) Causes:
    This is by design, since outlook uses X.500 Address to identify users (NOT SMTP Address) within Exchange Organization. And we cannot change this behavior.

    You could "Accept Answer" for this summary to close this thread, and your action would be helpful to other users who encounter the same issue and read this thread. Thanks for your understanding!

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Niranjan T Pattana Shetty 286 Reputation points
    2022-04-11T13:04:12.92+00:00

    Hi Joyceshen-MSFT,
    I posted this question in multiple forums and you were the first one to revert with a reply, many thanks for the firstly..... I too started feel the same thing after checking all Outlook options, looks like this works that way by design, anyways thanks again or looking into this.

    0 comments
  2. Aleksandr Reznik 1 Reputation point
    2022-06-13T17:03:05.47+00:00

    Unfortunately, this behaivour is probably by design (the way Microsoft program it by some unknown reason :) ).
    I wrote my own powershell script to perform export to CSV. It export specified set of folders with subfolders. And always get SMTP type email address from Outlook:
    https://it4it.solutions/2022/06/13/exporting-mails-from-microsoft-outlook-to-csv-file-with-powershell/

    0 comments