importing contacts from Excel

  • Thread starter Thread starter christine
  • Start date Start date
C

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
 
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.
 
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
 
Back
Top