Importing excel data into Outlook contacts

G

Guest

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?
 
K

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
 
G

Guest

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!
 

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 to outlook, zip code column will not come with the rest 1
importing from Excel 1
Import Contacts From Excel to Outlook Not Working 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Problem importing data from Excel into Outlook 2007 Contacts 3
Problems Importing Excel to Outlook 1
Importing contact from excel. some missing and "file as" not consi 4
Importing Data from Excel 2

Top