Transform range of cells into email addresses

  • Thread starter Thread starter William
  • Start date Start date
W

William

I'have got a column of a sheet in Excel 2000 filled with email addresses
but these are not recognized as email, despite they are in the right
form ([email protected]), I mean that they are not linked as an URL
(mailto:.....)
I think that this had occured because the sheet wasn't manually edited
but it could be imported from a database. In fact, no sooner as I edit
one with F2 and I press Enter, it becomes linked.
Since they are about 5000 addresses, how can I manage to transform them
automatically?
Hy,
William
 
William,

Assuming your email addresses are in column A, insert a new column B,
and in B1 use the formula

=HYPERLINK("mailto:" & A1,A1)

Copy down to match your data.

Unfortunately, you can't convert the formula to valid mail links and
get rid of the extra column, AFAIK.

HTH,
Bernie
MS Excel MVP
 
Thank you very much. It's a pity that, even though my default mail
client is Netscape Mail, the hyperlink are opened with Outlook! Anycase...
Warm regard,
William
 
I use OE as my email client at home, but I used to use Netscape Messenger.

I tried this with xl2002, NS 4.78, win98.

I put a formula in A1:
=hyperlink("mailto:test.test.com")

I clicked on it and Outlook Express started.

I started Netscape,
then Edit|Preferences
Mail and Newsgroup Category
I checked: "Use Netscape Messenger from MAPI-based applications"

I clicked on the =hyperlink() cell again and Messenger started.

When I wanted to turn it back, I unchecked this box,
started MS Internet explorer,
tools|internet Options|Programs tab
and changed the email program to something else (it was OE).
Then I applied and changed it back to OE.

(It seemed to want to be toggled off, then on to take affect.)

Maybe you could see if that helps for you.
 
Unfortunatly, even if I knew and used that option (in Netscape 7.1 is
"Use Netscape Mail as the default mail application"), I obtained no result.
I tried also to deselect and restart Netscape, and to select again and
restart. It's a real pity!
William
 
Back
Top