How do I convert email addresses to clickable links?
 

I have imported a column of email address. How do I make them clickable
links to email.
--
Rick Wetzel

Rick,

Highlight the range you wish to add email addresses to, then, switch to your
VBE environment by pressing Alt-F11 and go to Immediate Pane by pressing
Control-G and enter the following command

for each rng in selection:rng.hyperlinks.add rng,"mailto:" & rng:next

http://HelpExcel

"Rick Wetzel" wrote:

I have imported a column of email address. How do I make them clickable
links to email.
--
Rick Wetzel