You have tow choices.

1) If you use a mapped netwrok drive like I:\ the two PC's must have the
drive mapped exactly the same. Youo can check the mapping by going to a
windows Explorer and going to menu

Tools - disconnect Network Drive

Don't disconnect but this window will give the Full Map name of the drive

2) Instead of using a mapped drive name (I:\)use a network name that starts
with two backslashes. (\\mycompanydrive\....)


"jlclyde" wrote:

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