Search results

  1. B

    Insert Hyperlinks for attachments in Userform

    Just For information -- it seems FSO can't be used to open files, but the little script below seems to work (from How can Excel VBA open file using default application). Sub runit() Dim Shex AsObject Set Shex = CreateObject("Shell.Application") tgtfile ="C:\Nax\dud.txt" Shex.Open...
  2. B

    Insert Hyperlinks for attachments in Userform

    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?
  3. B

    Insert Hyperlinks for attachments in Userform

    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?
  4. B

    Insert Hyperlinks for attachments in Userform

    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...
  5. B

    Auto Preview Attachment in Inspector Reading Pane

    I'd like to create a user form that would work with the mail Inspector object. The form would have up/down arrows that would let me scroll through mail items, viewing them in the Inspector (the same functionality as the arrows already available on the QAT). And also a command button to forward...
Top