Activate List of Email Hyperlinks

[Guest]

I have a column of 700+ email addresses that are not hyperlinked. I know how
to make each individual link live; however, given the number involved, that
would take forever! Does anyone know a way to activie the entire column?

Thanks,
Sharen

 

[Peo Sjoblom]

You can use a macro

http://www.mvps.org/dmcritchie/excel/buildtoc.htm#MakeEmailLinks

same site has info on how to install a macro as well

 

[Guest]

Thank you for your help. I've followed the instructions exactly as written,
but I'm getting a "Compile Error" that says "Next without For." The word
'next' is highlighted just before the word "cell" and "end sub."

Problem is... I have no idea how to fix the error. Can you help me with
this? I really appreciate your expertise!

Sharen

 

[Peo Sjoblom]

You need to select all email addresses before you run the macro
1 select the range(s)
2 press Alt + F8 and click run or click tools>macro>macros and click run

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

Thank you, thank you, thank you! It worked!

Sharen