Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Associate name with email
I have a column of names and a column of email addresses. Is there any way
to merger them into a single hyperlink that shows the name and sends to the email address? |
#2
|
|||
|
|||
Hi jswafa
Try this : With the names in column A and the E-mail addresses in column B try this Sub test() For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s) If myCell.Value Like "?*@?*.?*" Then ActiveSheet.Hyperlinks.Add Anchor:=myCell.Offset(0, -1), _ Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Offset(0, -1).Value End If Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "jswafa" wrote in message ... I have a column of names and a column of email addresses. Is there any way to merger them into a single hyperlink that shows the name and sends to the email address? |
#3
|
|||
|
|||
Worked great, Ron - thanks for the tip!
"Ron de Bruin" wrote: Hi jswafa Try this : With the names in column A and the E-mail addresses in column B try this Sub test() For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s) If myCell.Value Like "?*@?*.?*" Then ActiveSheet.Hyperlinks.Add Anchor:=myCell.Offset(0, -1), _ Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Offset(0, -1).Value End If Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "jswafa" wrote in message ... I have a column of names and a column of email addresses. Is there any way to merger them into a single hyperlink that shows the name and sends to the email address? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
Activate email column to hyperlinks | Excel Discussion (Misc queries) | |||
Help me Please!! Need hyperlinks to show actual email address! | New Users to Excel | |||
Shut off email address from linking to email program? | Excel Worksheet Functions | |||
How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions |