importing contacts from Excel

[christine]

I am having a problem when importing contact info from
Excel. My Excel file has fields for 3 e-mail addresses
and e-mail display names per contact. When I import the
very first time all is well. When I import once a week to
update e-mail 1 from the previous week becomes e-mail 2
and e-mail 2 becomes e-mail 3 etc if those fields being
imported were blank. Only those e-mail fields that
actually had data in them in Excel import properly.
Everything else just shift email 1 into email 2 and e-mail
2 into email 3. I need Outlook to delete an e-mail
address if it is no longer in our Excel file not shift
it. I cannot delete and reimport contacts each time in
Outlook from scratch because then I have to redo extensive
distribution lists to keep them accurate and to keep the
UPDATE button working. I have tried putting text like "no
e-mail 2" into the fields in excel but then I have each
contact name listed 3 times when I use the address book
usually 2 of the 3 times the e-mail address will not work
because it is "no e-mail 2" etc. This is really causing a
problem. Any suggestions on how to import and update
contacts from Excel without having e-mail addresses shift
but have them blank out if they are blank in those fields
in Excel?????????
Please Help

Thanks

Christine

 

[Peggy]

How did you get the Excel file imported into contacts in
Outlook. When I attempt to do so, I receive an error
message that says there are no named ranges in the Excel
worksheet. I have named the range in numerous ways but
with no success.

Thanks for any help you can provide.

 

[Sue Mosher [MVP]]

You might try exporting a small subset of your contacts so you can see what a properly arranged Excel import file should look like. The named range should cover both the column headings and the individual data rows.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm