 |
 | 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 / September 2004import contacts from excel 2000
In an Excel 2000 worksheet one column is "name" other is "email". When I like to import I can't click lower. If I can click lower just email adresses imported to Outlook. Names are filled (elektronikus levelek) by Outlook. What can I do? Can you please explain by what you when you say "click lower"? Is your "named range" set correctly? Does this happen if you save your Excel worksheet as a CSV file and import that? 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 > In an Excel 2000 worksheet one column is "name" other is "email". When I like > to import I can't click lower. If I can click lower just email adresses > imported to Outlook. Names are filled (elektronikus levelek) by Outlook. What > can I do? In the Excel worksheet I have two columns and I'd like to choose them in Outlook importing window. I can choose only one of them. If I can choose both just emails imported by Outlook. For your second question my "named range set correctly. I did't try csv format because I thought It's easier a word documentum convert to Excel worksheet. „Karl Timmermans” ezt írta: > Can you please explain by what you when you say "click lower"? Is your > "named range" set correctly? Does this happen if you save your Excel [quoted text clipped - 8 lines] > What > > can I do? Since you're converting from MS Word to Excel, try saving the Excel worksheet as a CSV file just to make sure you only have 2 columns and also make sure that you "manually" map the fields. If that doesn't work - then there is a data format issue somewhere along the way. You're CSV file should look like this (first line will be your header row using whatever names are in the Row#1 columns) PersonName,PersonsEmailAddress SomeName,someperson@someaddress.com If you have more then one comma <between> the two fields - that will be the source of your problem. 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 > In the Excel worksheet I have two columns and I'd like to choose them in > Outlook importing window. I can choose only one of them. If I can choose both [quoted text clipped - 16 lines] > > What > > > can I do? Enter "field name in where you want the data to go into Outlook" in A1 and "field name in where you want the data to go into Outlook" e-mail in A2. This eliminates the need to "map" the data during the import process later. Next, highlight the relevant cells for the import, and select Insert>Name>Define. Now give the cells a name like Import or anything other than "name" or "e-mail". THe name that you give the cells are irrelevant. This tells OL what to bring in. Save as XLS file. Open OL, Import, and select from Excel. Browse to file, and the rest is easy. There is no mapping necessary because OL reads the two field names that you created in row one. Randy > Since you're converting from MS Word to Excel, try saving the Excel > worksheet as a CSV file just to make sure you only have 2 columns and also [quoted text clipped - 39 lines] >> > What >> > > can I do? If you don't map the fields to the specific Outlook fields (and the column (field) names in the XLS file don't correspond to an Outlook field name) - how does Outlook know where to map the fields? The description provided in your message is accurate only for those circumstances where Outlook can "automap" the inbound field names to it's own equivalent and you're sure that the two actually mean the same thing. Simple example to illustrate this with 2 fields is as follows: Name,Addr What Outlook field should "Addr" be mapped to automatically? If you try this, you'll find that it doesn't get mapped at all since Outlook has no way of knowing what this field means. Depending solely on Outlook's "automap" causes many people to wonder why some of their data doesn't get imported or alternatively gets imported into some other field in error). 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 > Enter "field name in where you want the data to go into Outlook" in A1 and > "field name in where you want the data to go into Outlook" e-mail in A2. [quoted text clipped - 52 lines] > >> > What > >> > > can I do? |
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.