Problem import/export contacts w/ Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I exported my Outlook contacts into Excel so that it would automatically
generate the header row, then I cut and pasted contact information from
several different Excel spreadsheets. When I tried to import the information
back into Outlook, it only imported the first 100 (approx) out of 600+
entries. There is no error message - it appears not to read the 'cut and
pasted' entries.

Any advice would be appreciated.
 
Make sure that your entire area that you want to import back is contained
within one named range including the first row which contains the
field(column) names. When you import the data - use that named range.

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
 

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

Outlook 2003 - Missing Email Address when Importing Contacts 0
how to import contact from excel to public folders 2
Importing Contacts From Excel 4
Importing Contacts 1
Problem importing data from Excel into Outlook 2007 Contacts 3
Importing Contacts From Excel - Incomplete Import 1
Contact file not visible when importing or exporting contacts 2
Excel 07 xls contact records imported by Outlook 2007 displaced 4

Back
Top