"Gary''s Student" wrote:
Hi Pete:
Let's say column A has text like:
but all "cold". In an adjacent cell, enter:
=HYPERLINK("mailto:" & A1,A1) and copy down to get a nice "clickable" set of
links.
--
Gary''s Student - gsnu200761
Hi,
I tried this and got a blue underlined email address. When I move the
cursor over it, it does show: mail to: the address, when when I click itr, it
does not open my mail app, but instead tells me "Cannot open specified file",
where the file is the worksheet where the email address is situated. I use
OSX on the mac. Any ideas? Thanks