Exporting contacts to excel
  Home FAQ Contact Sign in
microsoft.public.outlook.contacts only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... contacts Profile…
 Up
Exporting contacts to excel         


Author: Roger
Date: Aug 13, 2008 09:35

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?
2 Comments
Re: Exporting contacts to excel         


Author: Diane Poremsky [MVP]
Date: Aug 17, 2008 12:12

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: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

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.

"Roger" discussions.microsoft.com> wrote in message
news:1F9AF701-F014-40B6-9CCA-BC10B59963EC@microsoft.com...
> 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?
no comments
Re: Exporting contacts to excel         


Author: Karl Timmermans
Date: Aug 18, 2008 11:27

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

"Roger" discussions.microsoft.com> wrote in message
news:1F9AF701-F014-40B6-9CCA-BC10B59963EC@microsoft.com...
>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?
no comments

RELATED THREADS
SubjectArticles qty Group
Export to excelmicrosoft.public.sqlserver.reportingsvcs ·
How can I transfer contact info from Excel to Outlook?microsoft.public.outlook.contacts ·