How do I import a contact list from excel to Outlook?


S

Shimmie

Hi,

I am having trouble importing a contact list in an excel spreadsheet into
Outlook.
I exported an existing contact group, then i added contacts in their
respective fields e.g. company > company, name > name.
then import it as a file>from excel spreadsheet 1997-2003, but it doesn't
add the contacts I added manually to the spreadsheet, only the ones that came
out from the export.

Can someone please help, i have like over 1000 contacts to add and i really
don't want to have to do them manually.

I tried re mapping, but no luck whatsoever.
 
Ad

Advertisements

K

Karl Timmermans

Problem is your "Named Range". If guess is right, you added new contacts to
the <end> of the worksheet that got exported which doesn't alter the scope
of the "Named Range" created by the Outlook export process.

Two choices:

#1 - Correct the "Named Range" in the Excel worksheet
#2 - Save the worksheet as a CSV file and import that file into Outlook
instead

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
R

radar9628

In order to prep my .csv file of webmail contacts for import into Outlook, I
have named the range. BUT, where does that named range 'live' and how do I
specify that particular name range file when I am importing into Outlook
Contacts?

THANKS!
 
K

Karl Timmermans

Confused by your response - "I have named the range but where does that
named range live............." in any case,

When saving your worksheet as a CSV file "named ranges" aren't used . The
entire worksheet will be saved by Excel when selecting the CSV file format
bypassing the issue of NR altogether. If you have corrected your "Named
Range" in Excel to encompass all of your rows/columns- no need to go the CSV
route.

Karl

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
R

radar9628

Sorry for the confusion. I did end up saving the Excel workbook as a .csv
file. I cleaned up the file and am left with about 5 columns of data to
import. While importing into Outlook, I matched the field names from the .csv
file to the appropriate Outlook field names. I followed this path: import
from another program or file/comma separated values (Windows)/browsed to my
file 'webmail.csv' & Do not import duplicate items/Destination folder:
Contacts/FINISH/ Error occurs. What info from error signature would be
helpful to resolve the problem?
 
K

Karl Timmermans

Assume from the response that we're now dealing with a completely separate
issue unrelated to named ranges. No idea what you mean by "what info from
error signature would be helpful to resolve the problem?". Whenever you
encounter "an error" - always provide <complete> info of exactly what was
encountered.

However, do know that Outlook can be very, very moody (moody = throws an
error more often than not) when it comes to importing data via the Outlook
import wizard with the "Do not import duplicate items" option set. Will have
to leave that for someone else to answer if they know of a solution to that
problem but from where I sit - it's an issue with Outlook itself which only
MS can fix (wouldn't hold your breath on that one). Your option would be to
"Allow duplicates" and clear up any dupes later or sort your Excel columns
(Name & Email Address) accordingly and clean up the dupes before you import.

Alternatively, you may find ContactGenie DataPorter Personal Ed of interest
if you're going to be importing on a regular basis.
Features: http://www.contactgenie.com/cg20features.htm
D/L: http://www.contactgenie.com/cg20dlorder.htm

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
Ad

Advertisements

R

radar9628

Clearly my attempts at communication aren't working for you. :O| I ask
questions so I can learn (e.g. 'what info from error signature would be
helpful...'). I don't know what is or is not important, so I'm turning to you
and this forum for help.

Error Signature:
AppName: outlook.exe AppVer: 12.0.6316.5000 AppStamp:4833a470
ModName: oladd.fae ModVer: 12.0.4518.1014 ModStamp:45417457
fDebug: 0 Offset: 00008c24

When I opened up the error report, I don't know how to get the content from
there to you - IF in fact it is even helpful. If it is, I'd appreciate a
suggestion.
Paula
 
K

Karl Timmermans

Error message aside - I do believe I addressed the very likely potential of
encountering an error message in the 2nd paragraph of my previous response
along with 2 options of how to deal with the problem.

Karl

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top