?
Solved

Fix Outlook Contacts by removing or splitting characters

Posted on 2011-03-15
2
Medium Priority
?
454 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 600 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 25

Accepted Solution

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

801 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