> I have a list of 100 e mail address I wish to transfer from an Excel
> spread sheet into Outlook
[quoted text clipped - 4 lines]
> Where am I going wrong?
> any help most appreciated
After you select the range, so you enter a name in the name field? That's
the field that usually contacts the cell name, to the left of the formula
bar.

Signature
Brian Tillman [MVP-Outlook]