Importing EXCEL files with multiple sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Judge - 01 Oct 2007 19:41 GMT

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.

Reply to this Message

Karl Timmermans - 01 Oct 2007 20:21 GMT

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

>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
[quoted text clipped - 11 lines]
>
> I will appreciate advice.

Reply to this Message