Solved

Import contacts from Excel to Outlook with custom categories

Posted on 2010-11-23
1
631 Views
Last Modified: 2012-08-13
A client of mine was using an old version of Goldmine to manage their contacts and are going to transition to just use Outlook. I was able to export all of the contacts into a CSV in Excel. I then cleaned them up to have the columns match the field mapping in Outlook. Importing them went well but I am now being told that they want them categorized in a special way. For example, in Goldmine users may have been a member of "Attorney" as well as "Legal Attorney". These attributes were listed in a columns called Key1 and Key2 which don't map to an existing field for Outlook. I want to set up categories within Outlook to match the categories they had and somehow have them automatically become part of these categories during import. I am not sure if this is possible or not but any options you can offer would be helpful as opposed to manually editing all 4,000+ contacts. Thanks in advance!
0
Comment
Question by:DDI4U
[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
1 Comment
 
LVL 5

Accepted Solution

by:
Pabilio earned 500 total points
ID: 34198798
Hi DDI,

I think that you can do as you need but from Outlook... here is a solution provided by Matthewspatrick on a similar thread

http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_24455037.html?sfQueryTermInfo=1+10+30+excel+from+group+import+outlook

Hope it helps,
Roberto.
0

Featured Post

Industry Leaders: 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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
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.

627 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