Hello DP13,
Do you want a hyperlink or attach?
For attaching documents:
Sub AttachMultipleFilesToEmail()
Dim outlookApp As Outlook.Application
Dim myMail As Outlook.MailItem
Set outlookApp = New Outlook.Application
Set myMail = outlookApp.CreateItem(olMailItem)
For i = 2 To 5
source_file = "C:\Work Files\" & Cells(i, 3)
myMail.Attachments.Add source_file
Next i
End Sub
Source: https://wellsr.com/vba/2018/excel/ex...th-attachment/
For creating a hyperlink, you would have to make sure that your email is in HTML format and then create the a HTML link.
<a href="url">link text</a>
Source: https://www.w3schools.com/html/html_links.asp
Bookmarks