Importing EXCEL files with multiple sheets

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

Guest

I have often imported contacts from a single EXCEL spreadsheet into Outlook
2003 Contacts. I just tried to do so again but the import process did not
work correctly. I then noticed that the EXCEL file contains four separate
sheets.

I have not before imported an EXCEL file containing several sheets into
Outlook 2003 contacts. I assume that there are steps that I will have to take
to import this EXCEL file, with its four sheets, that are beyond the simpler
method that I use to import a single EXCEL sheet. What are those extra
steps? What is the best way to prepare an EXCEL file containing several
sheets for export into Outlook Contacts?

I will appreciate advice.
 
Make sure a "named range" is defined for each area that you want to import
since that's what the Outlook importer is looking for. Failing that, save
each worksheet that you want to import as a CSV file and import those files.

Karl

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
Back
Top