Importing contacts from Excel to Outlook...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to import a list of contacts from an Excel spreadsheet to Outlook

In Outlook I click on 'File', 'Import & Export', go through the steps.. then when it gets to the end it says

'The Microsoft Excel file .... has no named ranges. Use Microsoft Excel to name the range of data you want to import.

Any ideas

Thanks
 
Open the worksheet. Select the data you want to import. Choose Insert | Name | Define and provide a name. THis creates a named range. Save the worksheet. Go back to OUtlook and try the import again.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Back
Top