Insert Hyperlinks for attachments in Userform

Status
Not open for further replies.

B Caspe

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
I would like use VBA to insert Hyperlinks for mail item attachments into an Outlook userform.

Mail items would be handled one at a time and the code would be run by a command button on the (inspector) ribbon of opened mail items. This would save all the item's attachments to the hard drive and then insert hyperlinks to these file locations into a userform -- either into a label or a textbox.

I've found some good ideas online but all are for Excel userforms / use excel functions. For example: Excel Tips From John Walkenbach: Adding A Hyperlink To A Userform

Any suggestions on accomplishing this on an Outlook userform?

If not, maybe an excel form or functionality can somehow be used?

Thanks for any suggestions
 
Last edited by a moderator:

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If you wanted to use a pretty link you can put the url in the ControlTipText or Tag property of the control and change the code to use that property - or just put the url in the code
objWeb.Navigate "http // the url goes here"

clickable-links.png
 

B Caspe

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Thank you for the quick and interesting response Diane, I will start working with it.

The examples you give use internet explorer and link to the web, what I want to do is use hyperlinks to open files on the hard drive. Could this also be accomplished?
 

B Caspe

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Thinking about this ... if the labels can be programmed to populate with the file paths of the saved attachments, then maybe the label click event could call a File System Object sub (etc) that would open the file?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
B Programmatically force html send and insert clipboard contents into body Outlook VBA and Custom Forms 0
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
witzker Outlook 2010 Insert Date & Time at the button of an OL contactform in red Using Outlook 2
P Insert link in email body to attached document in Outlook 365 Outlook VBA and Custom Forms 0
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
R How Do I insert images in and Auto Reply Using Outlook 3
L Automatically Insert Recipient Name from To Field Outlook VBA and Custom Forms 33
Diane Poremsky Create Task or Appointment and Insert Selected Text New Slipstick.com Articles 0
D Outlook task insert Outlook VBA and Custom Forms 3
A Auto Insert of filename when selecting 'Remove Attachment' Using Outlook 1
K Insert screenshots issue Using Outlook 2
makinmyway Recent Files Not Updating when Using Insert Hyperlink in Outlook 2013 Using Outlook 0
L Insert Photo to Contact Using Outlook 23
K OL2010 Button to Insert First Name Outlook VBA and Custom Forms 6
K OL2010 Button to Insert First Name Using Outlook 1
witzker insert Date & Time (HH:mm) no (ss) in userform Using Outlook 6
A insert Date & Time in userform Using Outlook 3
K Macro to insert attachments Using Outlook 1
C Insert a Date Picker for Send Mail Subject Using Outlook 1
C Insert date in Subject through date picker Using Outlook 0
mrje1 Opening a task the Insert Tab Option is not showing up and organizing Tasks Using Outlook 9
H Insert Specific Text before Subject for New mails and reply Using Outlook 3
R insert picture tab grey Using Outlook 1
K Outlook insert clip art, no results found...address book contacts only show up Using Outlook 5
J Form design - how do I insert an automatic date/time field? Using Outlook 2
M Can I insert pictures from a url address (from web) without downloading ? Using Outlook 1
M Insert clip art, shapes, smart art, chart and screenshot greyed out in OUTLOOK 2010 Using Outlook 2
T My Outlook 2007 - (Public folder-Calendar can't insert to My Favourite)but other calender can insert Using Outlook 1
R Outlook 2003: Insert, Item: Unable to insert an old email into a new email Using Outlook 2
L Outlook 2010 Insert file issue Using Outlook 1
Y Ideas: Insert an error code or give a short description of what you are trying to accomplish or fix.__ Using Outlook 1
C Ideas: Insert an error code or give a short description of what you are trying to accomplish or fix.__ Using Outlook 1
G enter key and space bar key insert characters into email Using Outlook 1
B How do I Insert a hyperlink (to company network) in an appointment in Outlook to distribute to attendees? Using Outlook 1
F Ideas: Insert an error code or give a short description of what you are trying to accomplish or fix.__ Using Outlook 2
L Outlook 2010: cannot insert tables or illustrations Using Outlook 14
S Insert 'Requested By' into Task entry Using Outlook 1
B Insert your business card into your email signature in Outlook Using Outlook 2
G How do I find/open Address Book in Windows7 and insert my Outlook Contacts? Using Outlook 3
T Outlook2003 can't insert object Using Outlook 4
J How do I view the ruler in an Outlook message and/or insert tabs? Using Outlook 7
L Forward Email and Insert Sender's Email address in body Outlook VBA and Custom Forms 3
D Insert Text and Send Outlook VBA and Custom Forms 1
D Re: How do i insert radio buttons in an email Outlook VBA and Custom Forms 1
G How to insert a json array into a calendar events Outlook VBA and Custom Forms 1
K insert text into current position of pointer in mailcompose Outlook VBA and Custom Forms 1
J Insert File Outlook VBA and Custom Forms 2
M Insert a File Outlook VBA and Custom Forms 3
G Task / Insert / Attach Item / Business Contact BCM (Business Contact Manager) 1

Similar threads

Top