Importing Excel Sheet to Outlook Contacts

Importing Excel Sheet to Outlook Contacts

Post by RGVuaXN » Mon, 16 Apr 2007 02:26:02


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

Post by Nick Hodg » Mon, 16 Apr 2007 03:18:23

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
XXXX@XXXXX.COM
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

 
 
 

Importing Excel Sheet to Outlook Contacts

Post by Gord Dibbe » Mon, 16 Apr 2007 07:18:13

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://www.yqcomputer.com/

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

On Sat, 14 Apr 2007 10:26:02 -0700, Denise < XXXX@XXXXX.COM >