I have a column of email addresses, but they are static. How do I turn them
into active cells that when clicked take me to a new email message in Outlook?
I have a column of email addresses, but they are static. How do I turn them
into active cells that when clicked take me to a new email message in Outlook?
Try this macro:
Sub email()
Dim r As Range
For Each r In Selection
ActiveSheet.Hyperlinks.Add Anchor:=r, _
Address:="mailto:" & r.Value, TextToDisplay:=r.Value
Next
End Sub
Just select the cells you want to convert and run the macro.
--
Gary''s Student
"Jerimoth" wrote:
> I have a column of email addresses, but they are static. How do I turn them
> into active cells that when clicked take me to a new email message in Outlook?
Hi
Mark the range of cells with the email addresses.
Edit>Paste as Hyperlink
--
Regards
Roger Govier
"Jerimoth" <[email protected]> wrote in message
news:[email protected]...
>I have a column of email addresses, but they are static. How do I turn
>them
> into active cells that when clicked take me to a new email message in
> Outlook?
How about using another column:
=hyperlink("mailto:" & a1,a1)
and drag down.
Jerimoth wrote:
>
> I have a column of email addresses, but they are static. How do I turn them
> into active cells that when clicked take me to a new email message in Outlook?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks