Solved

Fix Outlook Contacts by removing or splitting characters

Posted on 2011-03-15
2
421 Views
Last Modified: 2012-06-27
Hello Experts!

I have a user who recently asked for help on importing his contacts from Google Contacts into Outlook. I'm not 100% if the problem originated from Google Contacts or even before it.

The issue is that we find all contacts with middle initials in the last name, and sometimes a dash in the last name. Although this is not a grave issue, it impacts the way contacts are listed. For example:

[First] [Middle] [Last] [Company]
[John] [] [J. Doe] [Acme Inc.]  ---> J. Doe, John Acme Inc (listed by J not D)
[Andy] [ ] [-- Katz] [ ] ---> -- Katz, Andy (listed at begining of contacts)
[ ] [ ] [A. Roberts] [ ] ---> A. Roberts (listed by A and not R)
[Jane] [J.] [Doe] [Acme Inc] ---> Doe, Jane J. Acme Inc (listed correctly as expected)

I'm not familiar with VB for Outlook and figure I need to do some character and string manipulation. I found a script that helped me reset the "File As" setting before I realized the problem was deeper than I thought.

Thanks in advance for your help!

-xt
0
Comment
Question by:xperttech
2 Comments
 
LVL 38

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 150 total points
ID: 35137692
I suggest exporting all contacts to excel, cleaning it up, delete all contacts from outlook, import bak into outlook.
0
 
LVL 24

Accepted Solution

by:
Sekar Chinnakannu earned 350 total points
ID: 35137707
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now