Well, the key to this problem is "I am in France" so going to assume you are
running under French regional settings. That being the case - here is what
the problem is:
#1 - When Outlook exports - the CSV file is created using a comma delimitor
regardless of what the regional setting is (and in turn expects a comma
delimiter when importing). In a perfect world, one would expect that a comma
would be used universally in all CSV files (but that's not the case when it
comes to Microsoft Office)
#2 - MS Excel uses the "list separator" character as defined in the Regional
Settings for the field delimiter when saving (or opening) a CSV file
#3 - If I was to make an educated guess - suspect that the Vista Mail import
process follows the same rules as MS Excel and therefore is expecting the
field delimter to be a ";" (semi-colon) which is used under French (France)
regional settings and therefore is the reason that everything appears in the
first field.
#4 - Why does Thunderbird etc work? Simple, it's expecting the "," separator
which is what Outlook used when creating the original CSV export file
If my suspicion(s) are correct - if you changed the regional setting on your
Vista machine to be US English (or any setting where the list separator
character is a comma), and then imported the very same CSV file via Vista
Window's Mail - it probably would work (don't have a Vista machine handy at
the moment to verify this prior to posting this here but fairly confident
based on your description that my suspicion is correct). Actually, once you
change the regional setting - Excel will read the file correctly as well
which you can check on any XP or Vista machine (that I know for sure).
To change your regional setting on the Vista machine - just go to All
Programs - Control Panel - Regional Settings and change the language
setting.
Karl
PS - I now acutely remember why we included the ability to change the CSV
field delimitor in our CG Exporter product and have to treat many
internationally created CSV files as "custom delimited" instead of "comma
separated" in our current Outlook import products.
___________________________________________________
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