Hyperlink not showing e-mail link

Hi

I need help with a hyperlink and e-mail address. Should I log a diffenrent thread or can i go on here

the new code

Please Login or Register  to view this content.

I have a cell which is allocated to a person. Then in cloumn AO i have the follwing formula in =HYPERLINK((VLOOKUP(AJ12,data!A:B,2,0)),(VLOOKUP(AJ12,data!A:B,2,0))), but it seems the hyperlink does not "activate" the e-mail address. I need either a VBA (added to the top code) or simplified formula to bring back the e-mail address fro a selected person. The above e-mail code works on this mail and also a CC mail

I eventually got the hyperlink active with =HYPERLINK("mailto :"&VLOOKUP(AJ12,data!A:B,2,FALSE)), but now it does not want to send the mail.