Range?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

When I try to import an xls file to Outlook, Outlook says, Use MS
Excel To Name The Range of data You Want to Import.

I have no idea what this means and how to do it so Outlook will be
satisfied to import the xls file which is this...Column A has a list
of First Names, Col B has the last names and Col C has their email
address's. The list is 155 items long.

Please help.
 
To name a range:

1. Select the cell(s) to be named
2. Click in the Name box, to the left of the formula bar
3. Type a one-word name for the list, e.g. MyAddresses
4. Press the Enter key.
 
I did this but it did not help in the end result for Outlook. Open
Outlook, Import, broswse to file, xls, select folder, Contacts, import
emaillist into folder Contacts. At this point, the Map Custom Fields
and Next are greyed out. I am really not sure what is going on here if
the problem is with the Excel file or Outlook.
 
I used Outlook 2002, and the steps were slightly different from what you
described. If you're using Outlook 98, the following MSKB article may help:

http://support.microsoft.com/?id=182728

If not, you could try posting your question to the following newsgroup:

microsoft.public.outlook

Specify which version of Outlook and Excel you're using, and describe
what you've done so far.
 
Back
Top