G
Guest
I have the following code below that creates an outlook email. I need to
hyperlink the holder variable how can I do this in VBA?
Sub Send_Msg()
Dim objOL As New Outlook.Application
Dim objMail As MailItem
Set objOL = New Outlook.Application
Set objMail = objOL.CreateItem(olMailItem)
holder = "\\server\share"
With objMail
.To = "(e-mail address removed)"
.Subject = "Test Email"
.Body = holder
.Display
'.Send
End With
Set objMail = Nothing
Set objOL = Nothing
End Sub
hyperlink the holder variable how can I do this in VBA?
Sub Send_Msg()
Dim objOL As New Outlook.Application
Dim objMail As MailItem
Set objOL = New Outlook.Application
Set objMail = objOL.CreateItem(olMailItem)
holder = "\\server\share"
With objMail
.To = "(e-mail address removed)"
.Subject = "Test Email"
.Body = holder
.Display
'.Send
End With
Set objMail = Nothing
Set objOL = Nothing
End Sub