question

Steve-5317 avatar image
0 Votes"
Steve-5317 asked KyleXu-MSFT commented

Outlook address book, entries are modified

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 !

office-exchange-online-itpro
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

My apologies, in the first line it should obviously say: All contacts are sorted "Last name, First name". Every now and ....

0 Votes 0 ·

@Steve-5317
I am writing here to confirm with you any update about this thread now?
If the suggestion below helps, please be free to accept it as an answer for helping more people.

0 Votes 0 ·
KyleXu-MSFT avatar image
0 Votes"
KyleXu-MSFT answered

@Steve-5317

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Steve-5317 avatar image
0 Votes"
Steve-5317 answered

Thanks KyleXu for looking into my issue. The contacts were all initially created in Outlook on my desktop computer. Previously I used a Samsung S5 with synced address book, there were no issues. After changing to the Huawei P30 Pro, I now have this unwanted modification from Last Name, First Name format to First Name Last Name in Outlook. Strangely, the contacts are still shown correctly on the phone. This happens to the contacts I have called, as for the shown Anton Schaerli. Nicola Affolter was not contacted in this period, so his name still shows correctly.135296-1.png135248-2.png135249-3.png



1.png (68.6 KiB)
2.png (40.4 KiB)
3.png (32.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Steve-5317 avatar image
0 Votes"
Steve-5317 answered

To get it back right, I have to open the contact, make ANY modification (not necessarily in the name fields) and save/close the contact. It shows correct again (Last Name, First Name) until I call it the next time.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KyleXu-MSFT avatar image
0 Votes"
KyleXu-MSFT answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Steve-5317 avatar image
0 Votes"
Steve-5317 answered

The Outlook options are (and always were) set correctly.

135635-4.png



4.png (10.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KyleXu-MSFT avatar image
0 Votes"
KyleXu-MSFT answered

@Steve-5317

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.



1231.gif (315.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.