I want to use VBA code similar to the code below to insert a hyperlink to a file on the server so that recipients of the email can access the file. Is it possible to insert a Hyperlink into the body of the email using code similar to the code below? If so, can you show me how it is done?
Public Sub TestIT() Set ol = CreateObject("Outlook.application") Set NewMessage = ol.CreateItem(olMailItem) With NewMessage .Recipients.Add "XXX@XXXXXXX.com" .Subject = "This is only a test!" .Body = "Please click on the link below..." & vbCrLf & vbCrLf 'How do I add a hyperlink to the email body here???? .Display End With End Sub