|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
November 6th 06, 06:32 AM
posted to microsoft.public.outlook
|
|||
|
|||
Importing from Excel to Outlook
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! 
|
|
#2
November 6th 06, 11:25 AM
posted to microsoft.public.outlook
|
|||
|
|||
|
Importing from Excel to Outlook
Perhaps format the Excel field as text?
"Bob" wrote in message ... 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!
|
|
#3
November 6th 06, 02:30 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
Importing from Excel to Outlook
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. "DL" wrote: Perhaps format the Excel field as text? "Bob" wrote in message ... 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!
|
|
#4
November 6th 06, 03:04 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
Importing from Excel to Outlook
I figured it out... You have to save the excel file as tab delimited. Then,
import that file into outlook. "Bob" wrote: 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. "DL" wrote: Perhaps format the Excel field as text? "Bob" wrote in message ... 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!
|
|
#5
November 6th 06, 04:42 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
Importing from Excel to Outlook
If a cell is formated in text it will display '0123' when this is entered
"Bob" wrote in message ... 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. "DL" wrote: Perhaps format the Excel field as text? "Bob" wrote in message ... 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!
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| importing from excel to outlook | Sheila | Outlook - Using Contacts | 1 | October 14th 06 06:36 AM |
| Importing meetings into Outlook using Excel | Victor | Outlook - Calandaring | 1 | October 10th 06 05:56 PM |
| Importing from Excel into Outlook | Rod | Outlook - General Queries | 1 | August 18th 06 06:08 PM |
| Importing Outlook Contacts via Excel | John Harris | Outlook - Using Contacts | 1 | July 19th 06 12:32 PM |
| Outlook 2003 when importing from Excel | Renae | Outlook - Using Contacts | 4 | March 4th 06 04:41 AM |
Hybrid Mode
