 |
 | 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 2006import Excel to Outlook, each field importing as separate contact
I am trying to import contact data from Excel to Outlook. Records are arranged in Rows, with column headings for Name, Email etc, but when it imports it is importing each individual data field as a separate contact. Help! Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping?  SignatureSue 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 am trying to import contact data from Excel to Outlook. Records are > arranged in Rows, with column headings for Name, Email etc, but when it > imports it is importing each individual data field as a separate contact. > Help! I am having the same problem. I have gone through the instructions more than 5X and still the same thing happens. I have verified the name range, made sure all of the mapping is correct and the data still comes out as individual contacts. Any additional help would be greatly appreciated. > Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping? > > >I am trying to import contact data from Excel to Outlook. Records are > > arranged in Rows, with column headings for Name, Email etc, but when it > > imports it is importing each individual data field as a separate contact. > > Help! Do you get a different result if you save the data to be imported as a .csv file and import that file instead of the spreadsheet? SignatureSue 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 am having the same problem. I have gone through the instructions more than > 5X and still the same thing happens. I have verified the name range, made [quoted text clipped - 3 lines] > >> Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping? >> >I am trying to import contact data from Excel to Outlook. Records are >> > arranged in Rows, with column headings for Name, Email etc, but when it >> > imports it is importing each individual data field as a separate contact. >> > Help! That worked!!!! Thank you so much!!!! > Do you get a different result if you save the data to be imported as a ..csv file and import that file instead of the spreadsheet? > [quoted text clipped - 10 lines] > >> > imports it is importing each individual data field as a separate contact. > >> > Help! |
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.