E-mail from Excel 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PA - 08 Nov 2006 17:17 GMT

I have a column of 350 e-mail addresses. I need to convert them all to
e-mail hyperlinks so that when I click on one of the addresses, an e-mail
item is generated.

I have selected them all and played around with the hyperlink button, but
cannot get it to work properly. An e-mail is created when an entry is
clicked, but it is always addressed to first individual on the list. What is
the correct procedure to convert these entries to working e-mail address
short of converting them one at a time.

Please help
Thanks
Paul

Reply to this Message

Ron de Bruin - 08 Nov 2006 17:35 GMT

Use this Paul

You can run this macro for column A

Sub test()
For Each myCell In Columns("A").Cells.SpecialCells(xlCellTypeConstants)
If myCell.Value Like "?*@?*.?*" Then
ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value
End If
Next
End Sub

Or insert a column with formulas

=HYPERLINK("mailto:" & A1,A1)

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I have a column of 350 e-mail addresses. I need to convert them all to
> e-mail hyperlinks so that when I click on one of the addresses, an e-mail
[quoted text clipped - 9 lines]
> Thanks
> Paul

Reply to this Message

PA - 08 Nov 2006 18:03 GMT

Thanks again Ron
Since I am not a VB user, I utilized the hyperlink fuction so I could
explain it if someone asked.

> Use this Paul
>
[quoted text clipped - 26 lines]
> > Thanks
> > Paul

Reply to this Message

Rate this thread: