Export excel sheet to outlook

S

Stefano

I have an Excel spreadsheet containing several addresses, I need to export
to a "Contact" folder in Outlook; my problem is that, after choosing the
destination file, I get the following error message:

The Microsoft Excel 97-2003 file
X:\xxx\xxxxxx has no named ranges. Use Excel 97-2003 to name ther range of
data you want to import

I tried to use the Help in Exce but I did not find any clear, step by step
explanation about how to do it.
Thanks in advance for your help.
Stefano
 
N

Nick Hodge

Stefano

Highlight the data in you Excel workbook (Including headers) and then go to
Insert>Name>Define... and after checking the address at the bottom is your
selected data, enter Database in the top box and click add. Dismiss the
dialog and save/close the workbook. Now you should be able to select this
during the import.

(If you have data on multiple worksheets, it is often best to move the sheet
you need to the left-most. If the other sheets have nothing on them,
deleting aids excel's comprehension in this type of activity)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
Top