Hyperlinks

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a data base in Excel with over 600 names, all the email address's are
in the one column.

Is there any way that I can turn these email address's into hyperlinks so
that when I click on an address it opens up in my email. Preferably by
selecting all of them and then doing whatever.

I have searched and tried a few things, but no luck. Is there a simple way
of doing this please?

--

Regards
Joe
Tasmania
(remove.not to reply)
 
Provided you have Excel 97 and up you can use this macro.

Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks)
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

You don't need the ScreenTip or TextToDisplay portions in the macro

Sub MakeHyperlinks()
Dim cell As Range
For Each cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add Anchor:=cell, _
Address:=cell.Value, _
ScreenTip:=cell.Value, _
TextToDisplay:=cell.Value
End With
Next cell
End Sub

For a better solution see MakeHyperLinkFormulas", which creates
hyperlinks with the HYPERLINK formulas.

If you are not familiar with macros, instructions to install and use macros in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
David, thank you for your reply. I am using Office XP Pro, does the same
apply to this version please?

Sorry I omitted to tell that in my original post.

--

Regards
Joe
Tasmania
(remove.not to reply)
 
Hi Joe
as Dadiv stated all versions above Excel 97 -> no problem with your
version, go ahead and try it out :-)
 
Back
Top