Outlook address book, entries are modified

Steve 21 Reputation points
2021-09-22T12:19:11.663+00:00

Hi all experts, have an issue with my company O365 address book. All contacts are sorted "First name, Last name". Every now and then, Outlook modifies my File As list to "First name last name". The comma is removed, and obviously the contacts are now in a wrong position as I get some First names between the Last Names. Just found out that this is for all contacts which I have called in the period since my last manual clean-up. Cell phone model is Huawei P30 Pro, with synced address book. This is the only address book on my cell phone and my computer, ie mix-up from another address book is excluded.
To make it clear, it want my list sorted A-Z: Biden, Obama, Trump. If I call Obama, the list in Outlook will get mixed up, showing Barack first, since Barack Obama comes before Biden Joe.
Please don't contact me for their personal phone numbers, I will not reveal them ;-)
Thanks for your help !

Exchange Online
Exchange Online
A Microsoft email and calendaring hosted service.
6,178 questions
{count} votes

Accepted answer
  1. KyleXu-MSFT 26,396 Reputation points
    2021-09-28T02:24:11.597+00:00

    @Steve

    I also try to change it with VBS, but I find that the “File As” doesn't support the format of “First, Last” (You could change it to "First, Last" manually, but this file cannot be set to this format automatically )

    135698-qa-kyle-10-09-11.png

    If you want to change them to one of the exist and supported format(Such as "Last, First"), you could use a VBS to change them:

    1. Enable the Macro for your Outlook:
      135676-qa-kyle-10-14-16.png
    2. Alt+F11 to open the VBS,
    3. Right click on Project1 and choose Insert > Module
    4. Copy and paste the macro into the new module. The macro is quoted from this article
      Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
    5. Change the "HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Contact\FileAsOrder" to the version of your Outlook. (Outlook 365/2016/2019 is 16, Outlook 2013 is 15)
    6. Then run this VBS to choose the format that you want: 135650-1231.gif

    If the response 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.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. KyleXu-MSFT 26,396 Reputation points
    2021-09-23T02:13:19.667+00:00

    @Steve

    Could you provided more detailed information about this issue?

    All contacts are sorted "Last name, First name"
    Outlook modifies my File As list to "First name last name"

    How do you create this contact? Do you mean create contact in Outlook? Could you provide a screenshot about it? Outlook Contact will not show in Address book, it just a Outlook client function.

    The name that show in Address book is controlled by server side(The value of Display Name):
    134475-qa-kyle-10-11-59.png
    134493-qa-kyle-10-08-55.png


    If the response 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.


  2. KyleXu-MSFT 26,396 Reputation points
    2021-09-27T09:06:04.247+00:00

    Strangely, the contacts are still shown correctly on the phone.

    It just a configuration for Outlook client, you could change it to the format that you want:
    135400-qa-kyle-17-03-44.png


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.