Neos-IT
asked on
How to change the firstname, surname display order of contacts imported from Excel
I have successfully imported a list of 423 contacts from Excel into Outlook contacts. The default view for imported contacts is surname, firstname. I want to be able to display them as firstname, surname. It is straight forward changing this setting for NEW contacts in tools - options - contact options default "File as" order but this only applies to NEW contacts, not the imported ones. I've tried adjusting the field mappings before importing but the result was the same. I don't fancy having to go into each one of the 423 contacts and change it manually so a global fix would be appreciated.
ASKER
Thanks. Yes, I tried that earlier (and just then) but it doesn't work. From the View|Arrange By|Current View|Customize Current View|"Sort By" I've tried the following:
a) firstname ascending, then by (none)
b) firstname ascending, then by lastname ascending.
Customising the current view doesn't seem to be overiding the "File as:" option from within the actual contact object itself.
a) firstname ascending, then by (none)
b) firstname ascending, then by lastname ascending.
Customising the current view doesn't seem to be overiding the "File as:" option from within the actual contact object itself.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, thx. I thought it may need a script but as I have no experience of scripting I hit this wall. Apologies for the next basic question; how do I create and run the script. Do I paste it into notepad and save it as a vbs file or will I need an app like visual studio?
ASKER
Many thanks Patrick, I called my friend who talked me through running a VB module within Outlook. It worked very well. The only slight issue (this is not a moan) was that it added a comma to 7 users who were listed and did not have a Lastname but I'll change them by hand - but hey I'm not complaining ;-) Many thanks once again, it really helped me out. kind regards, Greg.
Neos-IT,
1) From Outlook, hit Alt+F11 to get to the VB Editor
2) Insert a new module, and paste the code there
3) Hit F5 to execute the code
Regards,
Patrick
1) From Outlook, hit Alt+F11 to get to the VB Editor
2) Insert a new module, and paste the code there
3) Hit F5 to execute the code
Regards,
Patrick
1) Select the Contacts folder
2) Select View|Arrange By|Current View|Customize Current View from the menu
3) In the Customize View dialog box, click on the Sort button, and choose your sorting options