Importing Excell date into Outlook trouble

[geno368]

I have an Excel spreadsheet of my contacts, and when in Outlook, I am trying to import them into contacts there. I get the following:


file has no named ranges. in Excel, name the range of date you want to import.
I am using Office 2007 and Vista Home Premium and would appreciate any help here. Thanks

[Kimberly]

Yes, Outlook requires the range to be named. To do so:

a) Select the range, including all the column labels and all the data
b) Go to the Formulas tab and click ‘Define Name’
c) Verify the ‘Refers to” box lists the correct range
d) Type the desired name… “data”, for example, in the Name textbox. No space characters are allowed. Then click OK to close the ‘New Name’ dialog box
Outlook 2007 also required that the Excel file be a version 97-2003, so you will need to save it as one.