How to setup hyperlink of file name and path through Excel via VBA

[Purujeet]

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 transferred 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

[Purujeet]

I have found how to put it in the Hyperlink of the file. Now I need to know how to add a routing slip to this email. Any help will be greatly appreciated. Code Below :

Sub CreateEmail()

Dim rcp, hlink, msg, subj
rcp = "
subj = "Please review this file"
msg = "Please review file located at: " & _
"%0A%0A" & "<file://" & ThisWorkbook.FullName & ">"
hlink = "mailto:" & rcp & "?"
hlink = hlink & "subject=" & subj & "&"
hlink = hlink & "body=" & msg
ActiveWorkbook.FollowHyperlink (hlink)
End Sub

[Gania]

You have two choices for this.

• First, if you use a mapped network drive like I:\ the two PC's must have the drive mapped exactly the same. You can check the mapping by going to a windows Explorer and going to Tools menu - disconnect Network Drive. Don't just disconnect but the window will give the Full Map name of the drive.
• Second instead of using a mapped drive name (I:\) use a network name that starts with two backslashes. (\\mycompanydrive\....).