• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

Inserting Hyperlink into Custom Outlook Form by EndUser

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.
  • 3
  • 2
1 Solution
David LeeCommented:
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.  
commengAuthor Commented:
OK, how would I write the code for the command button?
David LeeCommented:
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

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

commengAuthor Commented:
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!
David LeeCommented:
You're welcome.  Glad I could help out.
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.)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now