Hello,
I am trying to figure out how to insert a link to an excel file in an email generated by vba. The hyperlink will be a folder path not a URL. See the code below. This hyperlink will show up in the spot labeled HYPERLINK below represented by the name "order sheet"
Dim OutlookApp As Object
Dim OutlookMail As Object
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
On Error Resume Next
With OutlookMail
.To = Insert email
.CC = ""
.BCC = ""
.Subject = "Order Request " & Date
.Body = "You have recieved an order request from " & Initials.Value & ". Please see " & HYPERLINK & " for details"
.Attachments
.Send
End With
Set OutlookMail = Nothing
Set OutlookApp = Nothing
Bookmarks