Save attachments from multiple selected items in Outlook (VBA)

This VBA sample illustrates how to save attachments from multiple selected items in Outlook.

4.8 Star
124,355 times
Add to favorites
E-mail Twitter Digg Facebook
  • This is not working for office 2013
    1 Posts | Last post June 13, 2018
    • Hi ,
      Earlier I was using it in office 2010 ; but after upgrading office 2013 it was not working ,let please guide on this share new update script .
      Vishal Sutar
  • Error from script in MS outlook 2016
    1 Posts | Last post June 05, 2018
    • I am not sure what this means but, every time i run the script i receive the error of "Failed to get the handle of the outlook window". Can any one help me with this ? My Job approved of this program to run on outlook in order to save me time, but I can't get it to work.
  • how to add date range to the script
    1 Posts | Last post March 15, 2018
    • This script is most helpful for me to extract the attachments for the email I choose, I've a requirement to filter the email for the specific date range which is editable one to filter and select to extract to the folder in computer. Need help in customizing the script, I'm not a Vba expert. I tried several scripts shared on forums, but it doesn't work.
  • Need the updated one for Outlook 2016
    4 Posts | Last post January 23, 2018
    • Need the updated one for Outlook 2016
    • Yes, I need an updated version for Outlook 2016 as well.
    • I have used this version with no issues on Outlook 10, 13 and 16
    • Commenting out (i.e. add an apostrophe before) the first line fixed this for me.
  • Delete the file if it exists
    1 Posts | Last post November 30, 2017
    • What would be the proper coding to check the path for the file name and if it exists to delete it?
  • Can I get time stamp from the email as well?
    1 Posts | Last post November 29, 2017
    • How can I get the time stamp from the email that the document was attached to also?
  • Limit of 200 saved attachments
    3 Posts | Last post September 25, 2017
    • Hi,
      Thanks for a great work saver! Works great, albeit with one small caveat:
      When selecting more than 200 items, the macro (at least in my environment) saves only 200 attachments. The message at the end of the macro shows a correct number (ie "377 attachments saved", nonetheless the real number of files in the target directory is 199.
      I am wondering if that's something related to the topic discussed here:
      Perhaps my environments puts some kind of limitation on the number of files saved?
    • Hello,
      Have you gotten this limit resolved? I am finally cleaning my emails and I have about 2000 emails that I would like to download the attachments. This bas is still awesome if I want to break 200 at a time; but it would be nice to get an idea about the 199 limit.
    • I encountered this problem and found that my macro was causing the SecureTempFolder to get filled up with copies of my attachments and not cleaning it up until the whole thing was finished.  I was able to work around it by having the macro kill the files from that folder after it was done with them.
  • Error Message
    1 Posts | Last post August 17, 2017
    • I keep getting a message that "No attachment(s) in the selected Outlook Items"
      Any idea what might be happening.
  • Overwrite old attachments
    1 Posts | Last post March 07, 2017
    • Thanks for the sample! 
      I would like to overwrite attachments with the same name based on the date that i received the mail (latest attachment should be saved). Is this possible?
      Also I would only like to save Excel files.
      I would really appreciate your help 
  • Saving only .Doc & PDF (no embedded pictures, jpegs etc)
    1 Posts | Last post December 07, 2016
    • HI, 
      THank you. This works like a charm!
      I only want to save documents like PDF, .Doc, .Docx. I do not want embedded pictures, jpegs etc
      Is there a way of doing this?
      Many thanks
11 - 20 of 47 Items