email list to import

[carol]

hi,

have a large list of email addresses in excel spreadsheet
and would like to import them into my contact file. have
not been successful in importing. i tried both excel and
cvs formats neither worked. pls help!!

 

[Robert Crayk MVP]

What happens, any error messages, as a test export your contact file to
Excel and try and get your spreadsheet in the same format

 

[Robert Crayk MVP]

That should read "Contact Folder"

What happens, any error messages, as a test export your contact file to
Excel and try and get your spreadsheet in the same format

 

[carol]

thx for your prompt reply. no error messages.

your suggested sounded good. i exported an existing
contact file to excel so that i would have the exact
column labels, etc. i then deleted the contact data and
pasted in just the email addresses under the email
column. i then tried to import back into the same contact
file both as an excel file and csv format but neither
worked. when i used excel, i did have two contact records
appear in outlook contact file but both were blank. so
don't know where to go from here! thx.

 

[Robert Crayk MVP]

How many Contacts are present in the Contact folder and how many are you
trying to import in and lastly what version of Outlook

 

[Karl Timmermans]

Re: Excel file - make sure that your "named range" is correctly set to cover
both the "header row" and all the data that you want to import. If not - it
will only import the data covered by the rows/columns defined in the "named
range" which may be much different then what you actually want to import.

Re: CSV - email addr not showing - make sure that the email address you are
looking at is the one you have imported to (also make sure the CSV file
contains the records/data you think it does).

In general - would also suggest you "manually" map your fields instead of
letting Outlook perform an "auto-map" since that doesn't always produce the
results you think/hope it will.

Karl
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com

 

[carol]

thx carl and robert for your help. i played with it some
more and left an old contact in the file folder that i was
importing to. tne imported a csv file of my contacts and
finally got it to work!! need to get more info
on "mapping' as my outlook 98 help does not list anything
under this subject. thx again.