How do I convert email addresses to clickable links?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a column of email address. How do I make them clickable
links to email.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert email addresses to clickable links? 3
Email notifications, does this forum have that deature? 4
How to create website link (Blue Clicky) 2
How to transfer email hyperlink to another cell 2
Email To button in excel 2
Convert 3,000 url's to enabled hyperlinked automatically? 4
Clickable Cells 2
How to format a cell as email address 4

Back
Top