Outlook 2003 when importing from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Renae - 28 Feb 2006 02:07 GMT

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

Reply to this Message

Renae - 28 Feb 2006 02:09 GMT

Please note that the word "crashes" is missing from the title. It
should read: Outlook 2003 crashes when importing from Excel

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Feb 2006 13:27 GMT

In the Excel file, did you create a named range that covers only the rows and columns of data you want to import?

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Renae - 02 Mar 2006 03:20 GMT

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

> In the Excel file, did you create a named range that covers only the rows and columns of data you want to import?
>
[quoted text clipped - 15 lines]
> >
> > Thanks

Reply to this Message

Sue Mosher [MVP-Outlook] - 02 Mar 2006 12:43 GMT

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

Signature

> Hi Sue:
>
[quoted text clipped - 28 lines]
>> >
>> > Thanks

Reply to this Message

Renae - 04 Mar 2006 03:41 GMT

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

Reply to this Message