importing from Excel

**PaulH7436** · April 26th 07, 01:56 PM posted to microsoft.public.outlook.contacts

I am trying to import from Excel and into Outlook 2003. The column for Zip
Codes is created by concatenating three other columns (including the dash).
Not all my rows have the zip+4 data. All my contacts were imported but only
the ones with a basic five digit zip code show the zip in Outlook. I tried
changing the column to TEXT, but no luck. Any suggestions are appreciated.
THANKS!

**Gordon** · April 26th 07, 02:22 PM posted to microsoft.public.outlook.contacts

"PaulH7436" wrote in message
news

I am trying to import from Excel and into Outlook 2003. The column for Zip
Codes is created by concatenating three other columns (including the
dash).
Not all my rows have the zip+4 data. All my contacts were imported but
only
the ones with a basic five digit zip code show the zip in Outlook. I
tried
changing the column to TEXT, but no luck. Any suggestions are
appreciated.
THANKS!

Do the concatenation in a column outside the import range. Then when that's
all done, do a Copy-Paste Special-Values from the column with the
concatenation results in into the column within the import range.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing from Excel	phd	Outlook - Using Contacts	12	November 19th 08 09:46 PM
Importing From Excel	D. Jarrett	Outlook - Using Contacts	6	February 12th 08 08:10 PM
Importing from Excel into Outlook	Rod	Outlook - General Queries	1	August 18th 06 06:08 PM
Importing from Excel	phd	Outlook - Using Contacts	0	July 9th 06 11:20 PM
Importing contacts from Excel	Joe Soap	Outlook - Using Contacts	1	February 23rd 06 06:55 PM