Importing Excel Sheet to Outlook Contacts

[Guest]

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

 

[Nick Hodge]

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
(e-mail address removed)
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

 

[Gord Dibben]

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 Insert>Name
Define you can import directly from the Excel workbook.


Gord Dibben MS Excel MVP