Importing From Excel To Outlook (Ofc 2000/XP Pro)

  • Thread starter Thread starter Susan Gerstenmaier
  • Start date Start date
S

Susan Gerstenmaier

Hi,
I'm am new at importing data from an Excel spreadsheet to
my Contacts in Outlook Address Book.
I seem to not be following the simple instructions
correctly. What does "Define a Named Range in your MS
Excel worksheet actually mean?
I am getting errors like "to many fields defined" and am
crashing.

Anyone who can help would be greatly appreciated.

Susan
 
What does "Define a Named Range in your MS
Excel worksheet actually mean?
Click to expand...

A "Range" is a collection/set of cells in Excel. For instance, "A:A",
meaning all the cells in column A, is a range. So is "A4:B6", meaning
the six cells A4, A5, A6, B4, B5, B6.

The two ranges I just mentioned are not named. If you refer to a range
often, it may be convenient to name the range -- that's giving it a
nickname or alias. So I might assign the name "prices" to the range
"A4:B6". The way to do this is to select the cells in the range, then go
to the excel toolbar where it displays the address of the current cell,
click in there and type
prices

That creates a named range "prices" which refers to cells a4:b6.

Once you've created a name, you can redefine it if you like. That way if
you suddenly have more prices, you don't have to go to everywhere you
reference the prices and update the formula.
 
Back
Top