Importing EXCEL files with multiple sheets

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

Karl Timmermans

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
 

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

Top