Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Activate List of Email Hyperlinks
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 |
#2
|
|||
|
|||
You can use a macro
http://www.mvps.org/dmcritchie/excel...MakeEmailLinks same site has info on how to install a macro as well -- Regards, Peo Sjoblom "Sharen" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote: You can use a macro http://www.mvps.org/dmcritchie/excel...MakeEmailLinks same site has info on how to install a macro as well -- Regards, Peo Sjoblom "Sharen" wrote in message ... 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 |
#4
|
|||
|
|||
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 toolsmacromacros and click run -- Regards, Peo Sjoblom (No private emails please) "Sharen" wrote in message ... 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" wrote: You can use a macro http://www.mvps.org/dmcritchie/excel...MakeEmailLinks same site has info on how to install a macro as well -- Regards, Peo Sjoblom "Sharen" wrote in message ... 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 |
#5
|
|||
|
|||
Thank you, thank you, thank you! It worked!
Sharen "Peo Sjoblom" wrote: 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 toolsmacromacros and click run -- Regards, Peo Sjoblom (No private emails please) "Sharen" wrote in message ... 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" wrote: You can use a macro http://www.mvps.org/dmcritchie/excel...MakeEmailLinks same site has info on how to install a macro as well -- Regards, Peo Sjoblom "Sharen" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks from a List, Excel 2000 | Excel Worksheet Functions | |||
Hyperlinks from a List, Excel 2000 | Excel Worksheet Functions | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Activate email column to hyperlinks | Excel Discussion (Misc queries) |