import email addresses from Excel spreadsheet

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?
 
G

Gordon

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?

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.
 
B

Brian Tillman [MVP - Outlook]

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?

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.
 
A

akm

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)
 
A

akm

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top