Thread: Excel help needed!!
View Single Post
Old 08-06-2005, 16:41   #10
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 46
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Excel help needed!!
Your right, it doesn't work. Its missing the mailto: bit of the hyperlink.

Add that in at the start...

=HYPERLINK(CONCATENATE("mailto:",A2, "@myaddress.com"), A2)

The , A2) at the end just makes the link look nicer as it doesn't show the mailto: bit.
gazzae is offline   Reply With Quote