Format email addresses?
 

Is there any way to format a column of email addresses, so if I click
on an address it will open up a new message in my email client?


--

The government is unresponsive to the needs of the little man.
Under 5'7" it is impossible to get your congressman on the phone.

....Woody Allen

Format email addresses?
 

Hi Steve

You can run this macro for column A

Sub test()
For Each myCell In Columns("A").Cells.SpecialCells(xlCellTypeConstant s)
If myCell.Value Like "?*@?*.?*" Then
ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
Address:="mailto:" & myCell.Value, TextToDisplay:=myCell.Value
End If
Next
End Sub

Or insert a column with formulas

=HYPERLINK("mailto:" & A1,A1)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Steve" wrote in message ...
Is there any way to format a column of email addresses, so if I click
on an address it will open up a new message in my email client?


--

The government is unresponsive to the needs of the little man.
Under 5'7" it is impossible to get your congressman on the phone.

...Woody Allen

Format email addresses?
 

"Ron de Bruin" wrote:
Is there any way to format a column of email addresses, so if I click
on an address it will open up a new message in my email client?

Or insert a column with formulas
=HYPERLINK("mailto:" & A1,A1)

Thanks Ron, that works great!


--

The government is unresponsive to the needs of the little man.
Under 5'7" it is impossible to get your congressman on the phone.

....Woody Allen