View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ggrizzell ggrizzell is offline
external usenet poster
 
Posts: 1
Default Naming a Data Range

I did this and it worked but not completely. How do I get addresses & phone
#'s in appropriate fields in contacts from excel worksheet

"JP" wrote:

Open the workbook, go to the worksheet with the email addresses,
highlight the data, press Ctrl+F3 and enter a name for your range.
When you do the import again, select that name to import.

--JP

On Oct 9, 2:31 pm, NotaTechy
wrote:
I am exporting my email addresses from an excel worksheet to Outlook 2003..
Outlook gives me an error "name range of data to export".
How do I name the range of data that I am exporting?