 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / February 2004Importing contacts from excel into outlook contacts
I have created an excel spreadsheet of contacts -- across the top row I have first name, last name, title, street address, city, state, zip, email, fax -- and am unable to import the list into Outlook. Help said the fields needed to be named do I went in and think I did that one at a time -- clicked on the cells one at a time and added them... then I went to import them into excel and I kept getting the message that the file I was trying to import was the wrong file type... please help! I don't really care what format the files start in just as long as I can get them into my contacts list...I would happy to create the source file in something else...text...word...etc...if that will make my life easier Thanks. Sounds like you added a "named range" for each cell. Simple solution for you is to just save your file in CSV format and import that into Outlook. By doing that you don't have to worry about Excel "named ranges" if you're not familiar with them. Karl  Signature__________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://contactgenie.claxton.com > I have created an excel spreadsheet of contacts -- across the top row I have first name, last name, title, street address, city, state, zip, email, fax -- and am unable to import the list into Outlook. > Help said the fields needed to be named do I went in and think I did that one at a time -- clicked on the cells one at a time and added them... > [quoted text clipped - 3 lines] > > I don't really care what format the files start in just as long as I can get them into my contacts list...I would happy to create the source file in something else...text...word...etc...if that will make my life easier > Thanks. You need to create a single Named Range covering the all cells in your spreadsheet. > I have created an excel spreadsheet of contacts -- across the top row I have first name, last name, title, street address, city, state, zip, email, fax -- and am unable to import the list into Outlook. > Help said the fields needed to be named do I went in and think I did that one at a time -- clicked on the cells one at a time and added them... > [quoted text clipped - 3 lines] > > I don't really care what format the files start in just as long as I can get them into my contacts list...I would happy to create the source file in something else...text...word...etc...if that will make my life easier > Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.