Exporting contacts to excel

[Roger]

I have outlook 07 and when I try to export my contacts to excell everything
exports except my zip codes. They show up as a 0. Does anyone know the fix
for this?

 

[Diane Poremsky [MVP]]

is it really a 0 or jut caused by cell formatting? I know new england zips
with leading 0's don't export well.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[Karl Timmermans]

Quickest way to determine if you have an Excel formatting issue or a data
export issue is to export the data to a CSV file which you can view in any
text editor. If your zip codes are correct when you look at the CSV file but
are incorrect when you open the same (CSV) file in Excel - answer is obvious
but you may also find that by exporting this way versus directly to an Excel
file - the problem may not show itself.

Karl
_____________________________________________________________
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com