Microsoft Outlook email - importing from Excel

Outlook Banter (http://www.outlookbanter.com/)

- Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)

- - importing from Excel (http://www.outlookbanter.com/outlook-using-contacts/46980-importing-excel.html)

importing from Excel

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!

importing from Excel

"PaulH7436" wrote in message
...
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.