Excel and Email addresses

  • Thread starter Thread starter Pete.K
  • Start date Start date
P

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?
 
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
 
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.
 
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
 
Gary''s Student said:
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
 
Back
Top