importing from Excel

G

Guest

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!
 
G

Gordon

PaulH7436 said:
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!
Click to expand...


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.
 

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

Importing contacts from Excel 5
importing to outlook, zip code column will not come with the rest 1
Problem importing ZIP codes from Excel 2002 into Outlook 2003 cont 1
Importing excel data into Outlook contacts 2
Format imported zip code to appear in Contacts w/o decimals? 1
How to merge Excel address columns when some zips begin with zeros 4
Why getting dup contact field data when import Excel to Outlook ? 7
Is there an automated zip code finder in Outlook? 2

Top