Inserting hyperlink into email text within VB code

A

AJ

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,

Arran
 

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

Similar Threads

Adding multiple subform fields to a mail item in Access 4
Adding multiple subform records to a mail item in Access 1
macro to include email signature 4
Inserting sender in voting response 0
Building Outlook email body in VB 1
Please help! Sending mail in Outlook from a COM addin. 0
Compile Error 2
Send Access Report in body of email 0

Top