Hyperlink to File name and path VBA Excel
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 |
Hyperlink to File name and path VBA Excel
I have found how to put int he 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. Thanks, Jay 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 |
Hyperlink to File name and path VBA Excel
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 |
Hyperlink to File name and path VBA Excel
It is going to be on a network drive. Coudl you show an example of
how to send an email with routing slip from excel? I can handle nailing down the correct drives. Thanks, Jay |
All times are GMT +1. The time now is 09:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com