Transform range of cells into email addresses

[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

 

[Bernie Deitrick]

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

 

[Dave Peterson]

Another option is to just add the mailto hyperlink with code.

Take a look at David McRitchie's site.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
(look for Sub MakeEmailLinks())

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[William]

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

 

[Dave Peterson]

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.

 

[William]

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