field as hyperlink opens outlook 2000

[wrmedia]

field contains email address - have made it a hyperlink but can't work out how to have it be an email link that just opens outlook 2000 with that email address

also input mask to make sure everything that goes into that field is in lower case

thanks

 

[Fubear]

Dim olApp As New Outlook.Application
Dim olMail As Outlook.MailItem
Set olMail = olApp.CreateItem(olMailItem)

olMail.to = "you@yourcompany.com"
olMail.Display

---
I'm a bit rusty on my automation - but this SHOULD do the trick, maybe a couple of properties are wrong but it should get you started.