Importing excel data into Outlook contacts

[Amateur]

I copied a Word table into Excel and then tried to import the data into
Outlook contacts. The column containing zip codes imported as a duplicate of
the column just before it, e.g. the state column. I changed the cell format
in excel to text and general and that didn't help. I moved the column but it
still imports as a duplicate of the column just before it. Any ideas?

 

[Karl Timmermans]

Are there any hidden columns anywhere? If you save your worksheet in CSV
format - is the info duplicated? If not, then either import the CSV file
into Outlook or open the CSV file in Excel and save it - then import from
the new worksheet. If it is duplicated when saving to CSV, open up again in
Excel and delete the extra column.

Karl
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

 

[Amateur]

Thank you so much. I didn't find any hidden files but saving it as a .csv
file did the trick. It imported beautifully. Thanks!