How do I convert email addresses to clickable links?

R

Rick Wetzel

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

galimi

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
 
Top