here is what I have done. It requires html tags within the HTMLbody portion. The link is in the tags <a href>. You also need to have a reference to Microsoft Outlook 11.0 Object Library if you are running Access 2003.
Dim myApp As New Outlook.Application
Dim myItem As Outlook.MailItem
Set...