Importing from Excel to Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to import to Outlook from Excel I'm having a problem with
zip/postal codes. All of my zips are in New Jersey and the first number of
the zip is zero (0). I set the excel worksheet to recognize that column as
"special, zip code" but when Outlook tries to pull in the data it's dropping
off all the zeros leaving me with a 4 digit zip, sans the zeros. So
frustrating. Please help!

Thanks!
 
Thanks for the response... I did try that. When I format as text, it drops
the zeros from the worksheet so they are not even present when Outlook trys
to pull the data over. Seems like such a simple thing, right??? I have been
recking my brain and Goolge to no avail.
 
I figured it out... You have to save the excel file as tab delimited. Then,
import that file into outlook.
 
Back
Top