import contacts from excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

--
__________________________________________
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
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:
 
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,[email protected]

If you have more then one comma <between> the two fields - that will be the
source of your problem.

Karl

--
__________________________________________
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.
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
 
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

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Back
Top