Exporting contacts to excel

R

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?
 
D

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]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

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.
 
K

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
 

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

Similar Threads

Zip Codes won't export from my outlook contacts to excel 2
importing to outlook, zip code column will not come with the rest 1
Importing contacts from Excel 5
Problem exporting contacts to excel 4
Importing Contacts From Excel 4
Exporting Outlook Contact "Categories" with contacts? 2
exporting 'File As' from contacts 2
Exporting Contact Email Addresses 2

Top