My macro will create an email to defined addresses. I want the words "RESPONSE column" to be hyperlinked to the document address ..... etc etc . How do I do that? TIA!!!
Rich (BB code):
Set xOutApp = CreateObject("Outlook.Application")
Set xMailItem = xOutApp.CreateItem(0)
xMailBody = "The RESPONSE column of the Employee Onboarding worksheet was modified on " & _
Format$(Now, "mm/dd/yyyy") & " at " & Format$(Now, "hh:mm:ss") & _
" by " & Environ$("username") & "." & vbNewLine & vbNewLine & "You're up, slugger!"