| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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) | |||
Hybrid Mode
