Page 1 of 6 123 ... LastLast
Results 1 to 15 of 88
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nifty add-on needed (OL 2002 SP-2)

    OK folks, can someone help me out here? I get a lot of file attachments and I'm looking for an add-on that can do some of the work for me. When I click on the attachment in the message header I'd like a 'save as' type dialog box to open that I can scroll through to select the save location. When the attachment has been saved, I'd also like it to automatically remove the attachment and append a comment stating the saved file's name and location. Anyone know if such a thing exists?

  2. #2
    New Lounger
    Join Date
    Nov 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    give EZDetach a try.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    I can provide some crude but free code if you are interested.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    OK, I'll bite. How crude?

  5. #5
    New Lounger
    Join Date
    Sep 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    I just tried the code on a message that had attachments. It stripped the attachments from the message fine, but I couldn't see that the file path had been appended to the message. The only new text visible in the message was the word "True". Is the file path stored as some type of message field?

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    Rats! Let me review the code to se if I messed it up.

    The file path and file name should be appended to the beginning of the item body. Were the attachments saved to the directory you had selected? Where did the word "True" appear? What format (plain text, RTF or HTML) was the message in?
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    New Lounger
    Join Date
    Sep 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    The attachments were saved into the directory I selected. The word "True" is at the beginning of the message (see attached screen shot), and the message is in HTML format. (I may be doing something wrong because I am not familiar with using macros.)

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    <P ID="edit" class=small>(Edited by JohnBF on 11-Nov-03 11:39. Further revisions.)</P>Attached. Rather than working on each attachment, it works on all attachments, in any item that can have an attachment. Let me know if you get any errors, as I stripped out some of my old test code (keep it around as a reminder to avoid the mistake next time!) There's one annoying thing about it, and that is that you have to re-select a folder for every file. I had code where this wasn't necessary, but that version wasn't able to then get the selected path. (If I was a professional coder I could probably fix that through a custom form and some API stuff, but I ain't anywhere that good.) Have fun!
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    I found a couple of problems, one related to a character conversion when I saved the code in a text file, see if the revised attachment works.
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    Hi John,
    I have just been working on something similar in between year-end figures requests and have come up with the attached userform. It obviously still needs a lot of work - there's no error handling and the functionality is fairly limited at this point - but it works for my current purposes. If you or anyone cares to test it and give me any feedback, I would appreciate it (though I can't guarantee being able to do anything about it anytime soon!)
    Regards,
    Rory

    Microsoft MVP - Excel

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    Rory, I couldn't get the form to import to to my Outlook 2003 VBE Forms folder, it errored out with the following log report:

    Line 8: Property OleObjectBlob in frmFileStripper had an invalid file reference.

    and since it wouldn't import I can't debug it.
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    Hmm, yes, something seems to have gone horribly wrong with my zip file processing! Try the attached - it's the frm file but renamed with .txt extension.
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    Sorry, Rory, but I'm still getting the same error. Line 8 is

    OleObjectBlob = "frmFileStripper.frx":0000

    Do you need to also include the file 'frmFileStripper.frx", or do I need to install "frmFileStripper.frm" from a certain location or set some VBE reference?
    -John ... I float in liquid gardens
    UTC -7ąDS

  14. #14
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    John,
    Sorry, you're quite right, I did need to include the frx file. Hopefully now attached!
    Regards,
    Rory

    Microsoft MVP - Excel

  15. #15
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Nifty add-on needed (OL 2002 SP-2)

    John,
    The fix for 1 is easy - the multi-select property of the listbox just needs to be changed to fmMultiSelectExtended. I'd be interested to see your revised UNC version when you're done!
    Regards,
    Rory

    Microsoft MVP - Excel

Page 1 of 6 123 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •