Importing Excel Sheet to Outlook Contacts
 

Please advise...I have always had trouble importing excel sheets to Access
and Outlook because an error appears stating I have no "name ranges" set for
this sheet. I have the "print_area" set...what more do I have to do??

Thanks anyone!
Denise

Importing Excel Sheet to Outlook Contacts
 

Denise

Whenever I import Excel stuff, I always name a range Database, it seems to
like that. I wonder if it doesn't like the underscore

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Denise" wrote in message
...
Please advise...I have always had trouble importing excel sheets to Access
and Outlook because an error appears stating I have no "name ranges" set
for
this sheet. I have the "print_area" set...what more do I have to do??

Thanks anyone!
Denise

Importing Excel Sheet to Outlook Contacts
 

Denise

How are you doing import into Outlook?

For some assistance.......................

Browse through this google search result for one method of importing the Excel
contacts to Outlook using a *.csv file saved from your Excel workbook.

http://snipurl.com/pssw

Alternate method................

In addition, if you give your data table in Excel a name through InsertName
Define you can import directly from the Excel workbook.


Gord Dibben MS Excel MVP

On Sat, 14 Apr 2007 10:26:02 -0700, Denise
wrote:

Please advise...I have always had trouble importing excel sheets to Access
and Outlook because an error appears stating I have no "name ranges" set for
this sheet. I have the "print_area" set...what more do I have to do??

Thanks anyone!
Denise