 |
 | 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 / January 2005Problem import/export contacts w/ Excel
I exported my Outlook contacts into Excel so that it would automatically generate the header row, then I cut and pasted contact information from several different Excel spreadsheets. When I tried to import the information back into Outlook, it only imported the first 100 (approx) out of 600+ entries. There is no error message - it appears not to read the 'cut and pasted' entries. Any advice would be appreciated. Did you expand the named range to include the additional rows?  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx >I exported my Outlook contacts into Excel so that it would automatically > generate the header row, then I cut and pasted contact information from [quoted text clipped - 5 lines] > > Any advice would be appreciated. Make sure that your entire area that you want to import back is contained within one named range including the first row which contains the field(column) names. When you import the data - use that named range. Karl Signature__________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com >I exported my Outlook contacts into Excel so that it would automatically > generate the header row, then I cut and pasted contact information from [quoted text clipped - 5 lines] > > Any advice would be appreciated. |
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.