Recent content by noobie

  1. N

    VB script code to save a specific email attachment from a given email

    You're welcome :) Just tell me if there are any problems.
  2. N

    VB script code to save a specific email attachment from a given email

    Oh, and I guess you can end the second for loop (with the j's) once you have found the specific attachment; efficiency :D If objAtt.fileName = chobjAtt Then objAtt.SaveAsFile file Exit Sub End If It may be problematic when you have several Excel files with...
  3. N

    VB script code to save a specific email attachment from a given email

    Okay, I tried to create such an array. I initially tried to store the attachments themselves within the array, and then just I would just have had to write 'a(2).SaveAsFile file', but that did not work. Hence I had to create some workaround: 1) Move through all attachments and store the file...
  4. N

    VB script code to save a specific email attachment from a given email

    It's not always that easy to grab a specific attachment. Example: the MailItem does have 3 Excel files attached and one screenshot embedded. Now you have 4 attachments in total. And if Outlook does not get the order right, it may be that the screenshot is exactly the attachment #3. Sometimes...
  5. N

    Outlook - Send New 20 Attachments through Email

    Is it necessary to have the Word Documents always in the same folder? Or is it possible to create some kind of temporary folder? Are these documents already ordered the way you want to send them? 50,000 documents is quite a big number, so I would do it the following: Create a folder called...
  6. N

    Saving And Deleting Outlook Attachments with Unknown Error Message

    So, now I tested the macro on another folder that I copied and I worked like a charm. 3,600 messages and only 2 error lines in the log, both of which I expected (file name too Long). So I come to the conclusion that there must indeed be a conflict with the digital signatures of the messages...
  7. N

    VB script code to save a specific email attachment from a given email

    Okay, okay, I should note that the End statement will end any procedures :D So Exit Sub will be the statement you need :)
  8. N

    VB script code to save a specific email attachment from a given email

    Okay, but that's what Diane already suggested. You will need to specify the number. Also, it may be a tad little bit more complicated than you imagined, but let's try: The (untested) code that I provide should loop through all the attachments of the MailItem and save the first Excel file it...
  9. N

    VB script code to save a specific email attachment from a given email

    Hey, you will need to put the "Set objAtt = Nothing" out of the For-Loop. Put it a line before the "Set fso = Nothing" Cheers, noobie
  10. N

    Macro for attachments download adjustment

    Hey, I am working on a similar project and I also encountered your problem. I solved it the following way: 1) select the parent folder 2) do all the stuff you want for the parent folder 3) loop recursively through the subfolders and do all the stuff for your subfolders ' In your main sub...
  11. N

    Saving And Deleting Outlook Attachments with Unknown Error Message

    Hey Folks, I am trying to write a macro that loops through an Outlook folder and its subfolders, looks for messages with attachments, saves them somewhere else (e.g. D:\...), and, if there has not been any error, deletes the specific attachment and writes down a log (I use that with in...
  12. N

    Outlook 2013 Does a Shared Folder Policy override a Digital Signature Setting for macros?

    So I wonder whether I should proceed like the following: Run the macro in Outlook, insert the vacation into the Excel sheet calendar, filter the sheet for the people who got vacation on a certain date, write a string like "Vacation Team Today: Member A Alias, Member B Alias, Member C Alias...
  13. N

    Outlook 2013 Does a Shared Folder Policy override a Digital Signature Setting for macros?

    Hey, thank you for your response! Obvious question: is there any way to solve the problem with the possibility of "fake appointments", though? And probably without having to start at beginning again?
  14. N

    Outlook 2013 Does a Shared Folder Policy override a Digital Signature Setting for macros?

    Okay, let's try to type it in a shorter version: Question as in the header. I wrote a macro that uses the shared folder option for the Outlook calendar. Appointments into other users' calendars still can only be placed via a macro (the authorisation (calendar permission) options are quite...
  15. N

    Outlook 2013 Does a Shared Folder Policy override a Digital Signature Setting for macros?

    No one willing to answer? Is the question understandable? Or is there another thread already which contains the answer? I tried to search within the forum, but with no success so far. Maybe you could redirect me to the certain thread.
Top