Outlook 2003 when importing from Excel

  • Thread starter Thread starter Renae
  • Start date Start date
R

Renae

I've named the fields, I've started the import wizard, I've mapped the
fields correctly, all is well until I hit finish. Then outlook hangs
and I have to end the program. When I restart outlook again, all I
have is a million new contacts in the file, all with one piece of
information in them, either a name, phone number or zip code.

What am I doing wrong?

Thanks
 
Please note that the word "crashes" is missing from the title. It
should read: Outlook 2003 crashes when importing from Excel
 
In the Excel file, did you create a named range that covers only the rows and columns of data you want to import?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Hi Sue:

Yes, it took me forever to figure out how to do that. I select the
full column and name the range such as name1 for first name and name2
for last name. Then address etc. Saved excel file, opened outlook,
import, get to the map fields, everything is fine, I have all the
ranges in my list to map, I check them out and finish, this is when all
goes awry and outlook crashes. I've even tried to do only one column
as a test, still does it. What could be wrong?

Thanks
Renae
 
You need one (1) and only one named range. Select all the data and create one range from that data.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
AHHH. That did it. Go figure! I thought it was harder than it is.
That was so easy! Thank you very, very much. I had way too many
ranges.

Pheww!

Renáe
 
Back
Top