Hyperlink in Outlook Message

[doulostheou]

I have created a form generator for my MS Access application that quickly allows users to create and use form e-mails, letters, and faxes.

However, I need to add a hyperlink into the body of my e-mail messages and have not been able to figure out how to do this through VBA. Any help or insight would be greatly appreciated. Thanks!

 

[rwweiland]

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 myItem = myApp.CreateItem(olMailItem)
With myItem
.Subject = "Put you subject line message here"
.ReadReceiptRequested = True
.HTMLBody = "<p> Put your body message here<a href = 'N:\Electronic Control\eRCN\RCN.mdb'>Click Here</a></p>"
.Display
End With

Hoepfully this works for you