What does it mean define ranges in Excell for import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 07 Sep 2006 17:09 GMT

I am trying to use an Excell database of names to be used in Outlook and it
asks for defining of ranges . Its a one column. I dont understand. Please
help

Reply to this Message

Ron Coderre - 07 Sep 2006 17:36 GMT

I believe MS Outlook is expecting a "named range".

See Debra Dalgleish's instructions on how to create one:
http://www.contextures.com/xlNames01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> I am trying to use an Excell database of names to be used in Outlook and it
> asks for defining of ranges . Its a one column. I dont understand. Please
> help

Reply to this Message

Gord Dibben - 07 Sep 2006 17:38 GMT

Ron

One column with just names?

Select and Insert>Name>Define>Add.

Give the range a name like MyRange and OK your way out.

If the one column is more than a list of names you may have to re-arrange.

i.e.

Name
Address
email address

would have to go into separate columns with headers

Name Address Email Address

Gord Dibben MS Excel MVP

>I am trying to use an Excell database of names to be used in Outlook and it
>asks for defining of ranges . Its a one column. I dont understand. Please
>help

Reply to this Message