Solved

Import contacts from Excel to Outlook with custom categories

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Set OWA language and time zone in Exchange for individuals, all users or per database.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

706 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

16 Experts available now in Live!

Get 1:1 Help Now