View Single Post
Old 08-06-2005, 17:22   #11
absthechatter
Inactive
 
Join Date: Dec 2004
Posts: 310
absthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really nice
Re: Excel help needed!!

Quote:
Originally Posted by gazzae
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.
Ah ha, that'll be the one.

Thanks for all your help again.

Abs
absthechatter is offline   Reply With Quote