Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Import contacts from Excel to Outlook with custom categories

Posted on 2010-11-23
1
Medium Priority
?
639 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
1 Comment
 
LVL 5

Accepted Solution

by:
Pabilio earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
Take a look at these 6 Outlook Email management tools which can augment the working and performance of Microsoft Outlook to give you a more rewarding emailing experience.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Suggested Courses

916 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