 |
 | 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 / June 2005Outlook Contacts Importing Error: 1 Record per field
I am having trouble importing from an excel spreadsheet into my Outloo contacts folder. After I setup the import and map the fields, Outloo imports each field's value in as a separate record i.e. 1000 record imported = 1000 contacts with only the name, 1000 contacts with onl the first line of the address, 1000 records with only the City, you ge the picture. I got the spreadsheet from a freind who was having the sam problem. I have even tried exporting from Excel into a CSV file the importing it into Outlook and get the same result. I am using Outloo 2003 SP1. Any help would be greatly appreciated Kelly, LVP Outloo when it's in a CSV, what do the fields look like? Are they properly laid out in the file, with comma or tab delimiters and each record on one line? (may be wrapped... but still one line) is the spreadsheet laid out with one complete record per row?  SignatureDiane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www.onenote-tips.net/ > I am having trouble importing from an excel spreadsheet into my Outlook > contacts folder. After I setup the import and map the fields, Outlook [quoted text clipped - 8 lines] > Kelly, LVP > Outlook Yes there is one record per row and all the columns have header fields. Here's a sample of the first couple of records in the CSV file: Company,First Name,Last Name,E-mail address,Phone,Fax,Street 1,Street 2,City,State,Zip,Salutation 1960 Family Practice Center,Stephanie,Trocko,stephanie@1960fp.net,+1 (281) 453-7917,+1 (281) 397-3755,837 FM 1960 West Suite 210,,Houston,TX,77090,Ms. 3D/International,Gerald,Vanbenschop,Vanbenschop@3DI.com,+1 (713) 871-7211,+1 (713) 871-7183,1900 West Loop South,Suite 600,Houston,TX,77027-3292, Any help would be greatly appreciated Kelly Clark > when it's in a CSV, what do the fields look like? Are they properly laid out > in the file, with comma or tab delimiters and each record on one line? (may [quoted text clipped - 14 lines] > > Kelly, LVP > > Outlook
|
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.