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
--
paul

remove nospam for email addy!



"Pete.K" wrote:

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?

Hi Pete:

Let's say column A has text like:



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

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

--
Gary''s Student - gsnu200761


"Pete.K" wrote:

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?

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

On Wed, 19 Dec 2007 02:55:00 -0800, Gary''s Student
wrote:

Hi Pete:

Let's say column A has text like:



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

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

"Gary''s Student" wrote:

Hi Pete:

Let's say column A has text like:



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

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

--
Gary''s Student - gsnu200761

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