Archive of Mr Excel Message Board

I am trying to import into Outlook a large list of phone numbers and names from an Excel spreadsheet. When I try to do this I get a message saying that there are no named ranges and to use Excel to name the range of data I want to import. Under "Insert" and "Name" I have tried to name the ranges, but I get funky results. Along the top row I have corresponding labels such as name, phone number, address, etc; there are 500 names in the A column that need to be imported. Any help would be greatly appreciated- I have tried every other avenue available to me and there seems to be no resource available that helps. Thank you very much!