Importing contacts from Excel to Outlook...

[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

 

[Sue Mosher [MVP]]

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

 

[Guest]

Thanks Sue... it seems to be working now.

 

[Guest]

Thanks a lot Sue... you just saved me at least 3 hours of cut-n-pasting.