import email addresses from Excel spreadsheet

  • Thread starter Thread starter RIGGINS
  • Start date Start date
R

RIGGINS

When I try to import a list of email contacts from Excel (I have Excel 2007,
but saved as 97-2003), I get an error messgae stating that the file name has
'no named ranges'. How do I identify the ranges? Are ranges identified from
Excel or identified while in Outlook?
 
RIGGINS said:
When I try to import a list of email contacts from Excel (I have Excel
2007,
but saved as 97-2003), I get an error messgae stating that the file name
has
'no named ranges'. How do I identify the ranges? Are ranges identified
from
Excel or identified while in Outlook?
Click to expand...

Named Range is an Excel function. Look it up in Excel Help.
Or (if you don't want to add that bit of knowledge to your Excel skills),
just save the file as a CSV and import that.
 
When I try to import a list of email contacts from Excel (I have Excel 2007,
but saved as 97-2003), I get an error messgae stating that the file name has
'no named ranges'. How do I identify the ranges? Are ranges identified from
Excel or identified while in Outlook?
Click to expand...

Open the spreadsheet, select all the rows and columns you wish to import, then
type a name (any name) in the Name field where you see the cell name when you
click one cell. Save the sheet. You've now named the range and can reference
that range in the import.
 
Had similar challenge, finally got range name part figured out, but when go
to map data at Outlook, the zip code field shows up as a cell reference (f6)
instead of a zip code number.
Any ideas on that one?
--
Thanks again for your help.
akm(XPpro,SP-2,IE-7,Office2003)
 
Ps: Sorry, am importing contacts, not just emails, but for the record, in
the 1st Excel record for mapping the zip code shows up as a cell ref and in
all the rest of the records it shows up as the state, ie duplicates the state
cell entry instead of the next cell in the row which is the zip code.
Ie...
name
address
city
state
state(in 1st record shows up as cell ref 'f6')
phone
--
Thanks again for your help.
akm(XPpro,SP-2,IE-7,Office2003)
 
Back
Top