I am trying to send a link to a user with a hyperlink to the file I am
working on via a button. I know how to create a hyperlink but I can
only put it in a range. I can not store it as a variable to be
transfered to the outlook mail. Any ideas on how to send mail with
vba and have the Body be a hyperlink to the file that I am sending it
from?

Thanks,
Jay