The step you need is an Excel question - how do you name a Range. Help in
Excel on this is non existant - I have been there a lot when helping clients
with this type of import.
Here ya go:
Highight the section of the Excel sheet you want to export.
The in the little white window top left, write a name for that Range eg
Contacts.
Shut Excel. (must do this)
Go to Outlook.
Use File Import/Export and this time you won't have a problem as you know
the range you want is "Contacts".
It will now go to the next step where you match the data fields and then
Import.
I hope this helps you at least a little bit!
Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
read my articles here:
www.judygleeson.com
www.acorntraining.com.au
Canberra, Australia
"Wasted end-user time due to lack of training accounted for the biggest
piece of the spoftware spending pie" -Gartner
"Milly Staples [MVP - Outlook]"
Export a few contacts from Outlook to Excel and compare the heading row in
each. Massage yours accordingly.
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.
After furious head scratching, Mike Rovinsky asked:
| I am trying to import excell spread sheets with student lists into my
| contact so I can have them in one location. I keep getting an error
| saying that I have not named a range of data and that I should do so
| in Excell
