Solved

Import contacts from Excel to Outlook with custom categories

Posted on 2010-11-23
1
626 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 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

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).
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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.

777 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