 |
 | 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 / May 2008Outlook driving me mad!
Hi, I am trying to import my contacts from an Excel spreadsheet into Outlook. I feel like I have tried EVERYTHING! I have saved my data as both an excel spreadsheet and in CSV format. I have made sure the columns AND the range of data is identified. I check and check again to make sure my fields are mapped correctly. I have tried eliminating symbols that might interfere (even though I don't see why they would). Every time I do the import, all of the data is imported EXCEPT for the address.... it gets the name, city, state, phone etc etc but ALWAYS leaves out the address! Does anyone know why this is happening and how I can fix it? If so, I would greatly appreciate some help. Thanks! JPorter is the full address in one cell or is the street address in a cell separate from the city, state and zip? Try changing the street address field to the one outlook uses so it doesn't need mapped. the address fields are: BusinessStreet BusinessStreet2 BusinessStreet3 BusinessCity BusinessState BusinessPostalCode BusinessCountryRegion HomeStreet HomeStreet2 HomeStreet3 HomeCity HomeState HomePostalCode HomeCountryRegion OtherStreet OtherStreet2 OtherStreet3 OtherCity OtherState OtherPostalCode OtherCountryRegion  SignatureDiane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM > Hi, > [quoted text clipped - 23 lines] > > JPorter I have the street address (including suite number) in one column, separate from city, state, and zip which are all in their own columns. Are you saying I should consolidate all of the address info into one column (address together with state, zip, etc) or separate it as much as I can into individual fields? > is the full address in one cell or is the street address in a cell separate > from the city, state and zip? Try changing the street address field to the [quoted text clipped - 50 lines] > > > > JPorter Use Individual fields. does the street address and suite include a comma? If so, remove it. SignatureDiane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM > I have the street address (including suite number) in one column, separate > from city, state, and zip which are all in their own columns. Are you [quoted text clipped - 62 lines] >> > >> > JPorter I'm having the same problem. It seems that when addresses are input into Outlook Contacts, they cannot be split up into AddressStreet1, AddressStreet2 and AddresssStreet3, but all end up dumped in a single 'Street' box, separated by carriage returns, which is then exported into Excel into a single cell, called AddressStreet1, including those carriage returns. AddressStreets 2 and 3 remain empty, but are there! Separating them out can be done by importing into Word replacing each carriage return with a symbol and then then importing back into Excel and splitting the text into columns using the symbol as the separation point. It's a real pain, but is possible. Is there a way of inputting the data into the 3 AddressStreet fields rather than the catch all 'Street' box? Thanks Reality is that the "street address" component for any of the 3 address field groups (home, business, other) is in fact stored internally by Outlook as a single field so there is nothing you can do in terms of "separating" the fields within the Outlook address blocks. The Outlook import wizard simply allows you to map individual street address fields in the import field map UI but all that happens is the various fields are still only consolidated into a single street address line which is also the only field that gets exported via the Outlook export wizard. Depending on what your requirements are, you may find one of the following links of interest: http://www.contactgenie.com/cg20features.htm - re: importing http://www.contactgenie.com/cgxfeatures.htm - re: exporting (can export multi-line street addresses as separate fields) Karl ___________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com > I'm having the same problem. > It seems that when addresses are input into Outlook Contacts, they cannot [quoted text clipped - 15 lines] > than the catch all 'Street' box? > 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.