Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / July 2005

Tip: Looking for answers? Try searching our database.

Export Outlook Contacts To MS Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Regina Rodler - 21 Jul 2005 08:31 GMT
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
Karl Timmermans - 21 Jul 2005 19:48 GMT
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

> Hello,
>
[quoted text clipped - 6 lines]
>
> Regina Rodler
Regina Rodler - 22 Jul 2005 16:58 GMT
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.

> 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
[quoted text clipped - 34 lines]
>>
>> Regina Rodler
 
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.