Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel hyperlink loses its path on save | Excel Discussion (Misc queries) | |||
Export file path from sequel to excel as hyperlink | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How do I display the full file path for a hyperlink in Office 2003 | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) |