Importing Excel Sheet to Outlook Contacts

D

Denise

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
 
G

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
 
Top