Export Outlook Contacts To MS Excel

R

Regina Rodler

Hello,

when exporting contacts to Excel, the column zip-code (German PLZ) in Excel
only shows zeroes.
How can I get the correct numbers ?
Thank you in advance.

Regards,

Regina Rodler
 
K

Karl Timmermans

This is just a guess but from the sounds of your description, appears that
the postal code is being saved as a numeric value and whatever you have in
the PLZ field is considered invalid or non-existant. Unless I'm mistaken -
the postal code is generally written as <##### City > within a German
address. What specific value is in the postal code field itself when looking
at it within Outlook (not as a complete address but the detail view of the
address) - is it just the 5 digit number? Is there any value in there at all
or has the postal code actually been entered with the name of the city?

If there is a value in the postal code field itself, you may want to try is
exporting the file as a CSV file and then opening that with Excel and see if
that makes a difference in terms of how Excel is picking up the data.

Another possible element that can add to how things are handled could be
based on what your computer's regional settings are set to on your system as
we're discovering from our European customers where MS Office language used
and regional settings do not always match.

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
 
R

Regina Rodler

Karl,

thank you very much for your answer.
It appears that the postal code is actually indeed handled as text by
outlook.

I will try to convert or get around it somehow.

Kind regards,

R.R.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top