Inserting hyperlink into email text within VB code



I have a button that sends an email using the following code:

Dim strBody As String
strBody = "Dear " & Me![RMA DATA subform1].Form![name] & "," &
vbCrLf & Chr(13)
strBody = strBody & "Your RMA request has been accepted and is
currently being processed your tracking number is " [Want to make this
part a hyperlink]

Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olMailItem)

myItem.SentOnBehalfOfName = "Technical Support"
myItem.To = Me![RMA DATA subform1].Form!

myItem.Subject = "RMA Request Accepted - RMA Number - " & [RMA Number]

myItem.Body = (strBody)
myItem.Display '<-- Optional -- Replace with myItem.Send to send
email without displaying first
AppActivate myItem

Is there an easy way to define this data as a hyperlink in the email
that a customer just can click on to automatically go to the tracking
website? Is it a problem that the email defaults to plain text only?

Thanks in advance,



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question