View Single Post
  #5  
Old February 1st 06, 10:20 PM posted to microsoft.public.outlook.contacts
Steelcity Gal
external usenet poster
 
Posts: 18
Default still problems - importing to outlook

Yes - it selects the entire column.

"Sue Mosher [MVP-Outlook]" wrote:

Sounds like you used Insert | Name | Create, which creates multiple ranges, not Insert | Name | Define, which creates just one. You need a single named range that covers all the data. To test, type that name into the box that appears just above the worksheet. Does it select all the data?

--
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


"Steelcity Gal" wrote in message ...
Error message was just an error has occured - save all infor - outlook will
restart. I did create a named range - named all columns at the name function
on top left - names were different from column headers. saved file - field
mapping was checked - did not see any problems. One header was imported
before an error occured so all I have in my contacts folder is 155 "state"
listings.
Outlook 2002 (XP small business)

"Sue Mosher [MVP-Outlook]" wrote:

YOu didn't say what the error message was or what version of Outlook you're using. To import from Excel, you must create a named range that covers the data you want to import, and then save the .xls file. You should also check the field mapping in the import wizar.

--
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


"Steelcity Gal" wrote in message ...
I am still having problems with outlook contacts. Created a new personal
folder ~ manually added 1 contact ~ it worked! tried to import from excel
(again) and again recieved an error message and outlook restarted. I made
sure that all excel fields and columns were named and all cells had something
in them. Do not understand why it wont import. I really do not want to enter
all manually! Any ideas?
(orig. message 1-26)


Ads