Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Inserting Hyperlink into Custom Outlook Form by EndUser

Posted on 2009-04-03
6
Medium Priority
?
466 Views
Last Modified: 2013-12-26
I have an outlook form with multiple text boxes.  I need the end user that uses this form to be able to insert a hyperlink to a file on the network.  Is there a way to enable hyperlinking on a text box in a Custom Outlook Form.
0
Comment
Question by:commeng
  • 3
  • 2
6 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 24059557
Hi, commeng.  

There's no way I know of to get a hyperlink to behave as a hyperlink in a textbox.  If the textbox will only contain the hyperlink string, then you can add a command button next to the textbox and use its click event to launch the URL in the textbox.  
0
 

Author Comment

by:commeng
ID: 24059592
OK, how would I write the code for the command button?
0
 
LVL 76

Accepted Solution

by:
David Lee earned 2000 total points
ID: 24060047
This will do it.  The code assumes that the name of the command button is "CommandButton1".
Function CommandButton1_Click()
    Dim objPage, objControl, varValue, objShell
    'Change the page name on the next line'
    Set objPage = Item.GetInspector.ModifiedFormPages("P.2")
    'Change the control name on the next line'
    Set objControl = objPage.Controls("TextBox1")
    varValue = objControl.Value
    If varValue <> "" Then
        Set objShell = CreateObject("WScript.Shell")
        objShell.Exec "explorer.exe " & varValue
    End If
    Set objPage = Nothing
    Set objControl = Nothing
    Set objShell = Nothing
End Function

Open in new window

0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Closing Comment

by:commeng
ID: 31566219
I was so close to having that on my own.  :D  I was doing a Sub not a Function, guess I will know for next time.  Thank you so much!
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24060157
You're welcome.  Glad I could help out.
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 24060171
Instead of the normal text box you could try using a Rich Text Box.  This page has a control that you could use that is based on a rich text box but with clickable hyperlinks: http://www.martin2k.co.uk/vb6/tips/vb_39.php

(Once you have registered the control, in the forms designer In the toolbox, right click and select Custom Controls, then scroll down the list to select the control.)
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question