email addresses will not import into outlook from excel

[Guest]

I exported contacts to Excel to combine and clean up contact files. When I
try to import them back into Outlook, email addresses are not imported. The
files were created in Outlook 2000, cleaned up in Outlook 2003, then resaved
as Excel 97-2003 files.

 

[Brian Tillman]

I exported contacts to Excel to combine and clean up contact files.
When I try to import them back into Outlook, email addresses are not
imported. The files were created in Outlook 2000, cleaned up in
Outlook 2003, then resaved as Excel 97-2003 files.

Are you specifying a named range?

 

[Guest]

Are you specifying a named range?

Hi Bill --

Outlook is not something I understand at all, and the concept of named
ranges is new to me. If you think this is the problem, I'll go learn how to
do it. If you can give me a quickie tutorial, so much the better.

Thanks so much!

Leslie

 

[Brian Tillman]

Hi Bill --

Who's Bill?

Outlook is not something I understand at all, and the concept of named
ranges is new to me. If you think this is the problem, I'll go learn
how to do it. If you can give me a quickie tutorial, so much the
better.

Start Excel. Click Help>Microsoft Excel Help. In the "Search for" box,
enter "named range". Click the search button. Read all about it. In
Outlook, also see Help on the topic "I get an error message when importing
information from Microsoft Excel" and the "How" subtopic under that.