Excel and Email addresses

[Pete.K]

Have received a long list of names and email addresses in a CSV file.
I would like to use the email addresses directly from the spreadsheet, by
clicking on the cell where the email address is. I am sure that I used to be
able to do this, but now it doesn't appear to work.

anyone any ideas?

 

[paul]

depends how you want to use the addresses.You can copy and paste one or as
many adddresses as you like into your adress feilds in you r emails.On my
excel sheets the emil address is acttually a HYPERLINK,you just click on the
address and the email program opens with hte recipient already loaded in TO

 

[Gary''s Student]

Hi Pete:

Let's say column A has text like:

(e-mail address removed)

but all "cold". In an adjacent cell, enter:

=HYPERLINK("mailto:" & A1,A1) and copy down to get a nice "clickable" set of
links.

 

[Gord Dibben]

Or a macro to change without the helper column.

Sub MakeHyperlinks()
'David McRitchie
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


Gord Dibben MS Excel MVP

 

[istella]

Hi Pete:

Let's say column A has text like:

(e-mail address removed)

but all "cold". In an adjacent cell, enter:

=HYPERLINK("mailto:" & A1,A1) and copy down to get a nice "clickable" set of
links.

Hi,
I tried this and got a blue underlined email address. When I move the
cursor over it, it does show: mail to: the address, when when I click itr, it
does not open my mail app, but instead tells me "Cannot open specified file",
where the file is the worksheet where the email address is situated. I use
OSX on the mac. Any ideas? Thanks