embedding user-defined hyperlink into auto-generated email

hello, I was wondering how to imbed a hyperlink into the body of an automatically generated email.

Ideally the hyperlink would be based on a cell value to allow a user to cut and paste a file path

example filepath
P:\Project Folder\project worksheet.xls


Here is the current autoemail VBA code I am using. So the filepath would be taken from
Sheet: Behind The Scenes D4

Please Login or Register  to view this content.