Make sure row 1 contains headers rather than data (Name, email address etc), then drag across all cells containing anything you want to import (including the header row), click Insert > Name > Define, and type a name.
HTH Tim Boswell Customer Support Specialist BG Group Service Desk * mailto:[EMAIL PROTECTED] * 0870 240 0890, TVP Ext 2727 ICL Helpdesk * mailto:[EMAIL PROTECTED] * 01782 777888, Int Ext 7241 4678 This email is intended only for the addressee named above. As this email may contain confidential or privileged information if you are not, or suspect that you are not, the named addressee or the person responsible for delivering the message to the named addressee, please telephone us immediately. Please note that we cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. The views of the author may not necessarily reflect those of the company. International Computers Limited, Registered in England no 96056, Registered Office 26, Finsbury Square, London, EC2A 1SL -----Original Message----- From: Celoxica Exchange [mailto:[EMAIL PROTECTED]] Sent: 23 October 2001 16:11 To: MS-Exchange Admin Issues Subject: Slightly OT. Creating Distribution list from Excel Slightly OT but if anyone can help I would be very grateful. I have a list of 1000 names and email address's in an Excel spread sheet. I would like to import them all to a personal address book so as I can easily create a distribution list. I was using the Import / Export wizard but this fails with the message the file to be imported has no named ranges. Use Excel to name the ranges. Can anyone help me with this please? We use Exchange 5.5 sp3 NT 4 sp6a Outlook 2000 Excel 2000 Thank you in advance for any help. Kevan Dickinson Celoxica Ltd 20 Park Gate Milton Park, Abingdon, Oxfordshire, OX14 4SH TEL: +44 (0) 1235 863656 DDI: +44 (0) 1235 825062 FAX: +44 (0) 01235 86364 email:[EMAIL PROTECTED] www.celoxica.com Reg No: 3209209 _____________________________________________________________________ This message has been checked for all known viruses by Star Internet delivered on behalf of Celoxica Ltd through the MessageLabs Virus Scanning Service. This email and any files transmitted with it are confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed. If you have received this in error, please contact the sender and delete the material immediately. Whilst this email has been swept for viruses, you should carry out your own virus check before opening any attachment. Celoxica Ltd accepts no liability for any loss or damage which may be caused by software viruses or interception or interruption of this email. List Charter and FAQ at: http://www.sunbelt-software.com/exchange_list_charter.htm List Charter and FAQ at: http://www.sunbelt-software.com/exchange_list_charter.htm
