Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I convert email addresses to clickable links?
I have imported a column of valid email address. How can I make them
clickable links to email. No problem if I type them but there are far to many. Help apprecited. Thanks. Rick Wetzel |
#2
|
|||
|
|||
Hi Rick
Try this one for Column B in the activesheet Sub test() For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s) If myCell.Value Like "*@*" Then ActiveSheet.Hyperlinks.Add Anchor:=myCell, _ Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value End If Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Rick Wetzel" wrote in message ... I have imported a column of valid email address. How can I make them clickable links to email. No problem if I type them but there are far to many. Help apprecited. Thanks. Rick Wetzel |
#3
|
|||
|
|||
small suggestion:
Instead of "*@*", the pattern "?*@?*.?*" will be more discriminating for email addresses. See http://mcgimpsey.com/excel/subs/converttomaillink.html In article , "Ron de Bruin" wrote: Try this one for Column B in the activesheet Sub test() For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s) If myCell.Value Like "*@*" Then ActiveSheet.Hyperlinks.Add Anchor:=myCell, _ Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value End If Next End Sub |
#4
|
|||
|
|||
Thanks J.E for this suggestion
-- Regards Ron de Bruin http://www.rondebruin.nl "JE McGimpsey" wrote in message ... small suggestion: Instead of "*@*", the pattern "?*@?*.?*" will be more discriminating for email addresses. See http://mcgimpsey.com/excel/subs/converttomaillink.html In article , "Ron de Bruin" wrote: Try this one for Column B in the activesheet Sub test() For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s) If myCell.Value Like "*@*" Then ActiveSheet.Hyperlinks.Add Anchor:=myCell, _ Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value End If Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make XL stop interpreting email addresses as highlighted links? | Excel Discussion (Misc queries) | |||
How do I export email addresses from excel to outlook? | Excel Discussion (Misc queries) | |||
Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions | |||
How do I format email addresses as Text only? | Excel Worksheet Functions |