A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Importing EXCEL files with multiple sheets



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 1st 07, 07:41 PM posted to microsoft.public.outlook.contacts
Robert Judge
external usenet poster
 
Posts: 25
Default Importing EXCEL files with multiple sheets

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.
Ads
  #2  
Old October 1st 07, 08:21 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default Importing EXCEL files with multiple sheets

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



"Robert Judge" wrote in message
...
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.



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem importing excel files into outlook contacts RobinSuz Outlook - Using Contacts 2 July 30th 07 01:24 AM
Importing OE6 dbx files without overwriting existing dbx files Jackanory Outlook Express 10 February 13th 07 12:08 PM
changing style sheets too-old-for-this Outlook Express 1 June 15th 06 03:02 PM
export multiple files Excel to Outlook, only one item appears confused Outlook - Using Contacts 1 May 3rd 06 09:08 PM
importing calendar from excel with multiple attendees tbo Outlook - Calandaring 0 March 23rd 06 05:46 PM


All times are GMT +1. The time now is 07:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.