there are many many different methods on achieving this.
Search UA and you will find a lot of discussions.
If you want to use a hyperlink you could right click on your hyerplink
field...then choose hyperlink...edit hyperlink...in the link to option select
This will put a mailto: in front of the emails and if you click on them then
outlook opens a new email with the address in the to field.
Another option would be to change the values to text datatype. Then use a
controls on click event with the sendobject method to create the email.
The sendobject method would be the programming way of
doing it. This way you can actually include db objects as attachments, or
insert information in the cc, bcc, subject, body of the email as well instead
of just bringing up a blank new email. Sendobject is fairly limited in the
respect to that it only allows ONE attachment at a time and only access db
objects. So if you would want to send more then one or outside files then
sendobject will not work for you.
You can find the whole syntax of sendobject here:here
Both of these methods are fairly limitted, so if you want more control then use
automation to create the email or redemption...!