outlook 2010 beta

  • Thread starter Thread starter tilmanj
  • Start date Start date
T

tilmanj

I am a member in a football club and other clubs. Now we use an excel list to
share the address. I would like to import it but I don't know how to convert
it so that outlook 2010 can read it.

My second guess was to import it via .csv file. But outlook doesn't support
the way excel separates the data. So I had to use Google. But then it was not
windows-coded. So I had to convert it with notepad++. Outlook doesn't support
utf8 data. So I have German cities with weird names(Like Gießen, my hometown)

Please make it easier!
 
Outlook's Import Wizard supports both Excel files and CSV files.
Why you think it doesn't remains a mystery since you provided no information
as to the problems you are having.
 
Since you did not elaborate as to the structure of your worksheet -
impossible to say whether or not it can be imported. It's not how "Excel"
separates data - it's how the worksheet was structured - two entirely
different things. Excel really has nothing to do with it.

Structure should be as follows:

First row - each cell/column represents a "field" and should be given the
name representing the contents of all cells beneath it in the column
(referred to as the <header row>)

Following rows: each cell should have related info for one field for one
contact

One row = one contact
One cell/column = one field of information related to one contact

Example:

Firstname, LastName, EmailAddress
John, Doe, (e-mail address removed)

If your worksheet is not structured as described above - you will have to
get your info formatted properly (not an Excel or Outlook issue - just the
way things work when dealing with data)

If you import from the Excel worksheet, you will need to create a "named
range" and if you're not familiar with "named ranges" - just save the
worksheet as a CSV file and import that instead.

Karl
--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
http://www.contactgenie.com
 
That was just the way I arranged it.
And Outlook didn't accept it.
I think you're just writing but you never tried out for yourself.

Excel separates data with a semicolon. Outlook separated the data only when
it using a normal "," comma. So I had to make open the file with google
tables so it creates a csv file separated with "," .

Tilman
 
The missing piece to this puzzle is the regional settings in use. Excel
(Office products in general) utilize the regional list separator which for
many European countries is the semicolon. Outlook on the other hand tends
to stay true to the comma as the separator for CSV (the Outlook
import/export wizards were not written by Microsoft and date back more than
a decade).

Karl
--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
http://www.contactgenie.com
 
Thanks for your help. Where do I post feedback so Microsoft does know about
this issue?

So now I need to find out how to do "named ranges" in the german edition...
;-)

Tilman
 
Am sure others would know the best place where you can post those kinds of
things.

There is a very quick solution to the problem. Change your regional
settings to any country where the "," comma is the list separator (US,
Canada etc) and save your worksheet to CSV then change the regional
settings back when done. If the issue is purely one of the delimitor - your
problem should be solved saving you from worrying about "Named Ranges" in
German (same as in English). Regional settings are independant of the
Office language in use.

Also, to be honest, not entirely sure how universal the issue is since only
had it reported once as problem for ContactGenie some 7-8 yrs ago from a
customer in France when the issue first became identified but have seen
this issue posted in other places several times since. At that point the
standard text file options for any ContactGenie program related to "import"
became the inclusion of both of the following
#1 - using the list separator as the default delimitor for CSV files
#2 - providing for "custom delimited" text file types should the above not
be applicable (i.e. files created in one country and sent to someone in
another)
- one of the two above options solves the problem no matter what the
contents of the file which is the extent of my concern about the behaviour.

Karl
--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
http://www.contactgenie.com
 
Back
Top