+ Reply to Thread
Results 1 to 4 of 4

How to copy all attachments of selected emails in order to paste them later for a folder

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    113

    Question How to copy all attachments of selected emails in order to paste them later for a folder

    I receive several emails with attachments related to the same folder. Without opening but by selecting these emails, I want to save all attachments into a specific folder.
    Is it possible to select emails and then by running the macro, copy all attachments so that I can later paste them into a desired windows folder?

    The closest macro seems like "Save attachments from multiple selected items in Outlook (VBA)" but the code is not robust. It produces problems for outlook 2016 and I have to find the targeted folder from the browsing pop-up. However, my target folder would already be opened on the background and waiting to get the required files.
    Last edited by 1tane1; 01-24-2019 at 03:39 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,442

    Re: How to copy all attachments of selected emails in order to paste them later for a fold

    See if this utility will do it for you.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: How to copy all attachments of selected emails in order to paste them later for a fold

    Thank you for your quick response. However, I create different folders for each case. So this method doesn't look like feasible for me since I need to locate the path into excel file. Also, I may receive any type of file in the mail.
    However, I may work on the code you provided

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,442

    Re: How to copy all attachments of selected emails in order to paste them later for a fold

    If you want to download any attachment use "*" as the type file.

    As for the path to download to: if there is a way you could "calculate" the path, then you could use a formula in this cell.

    The same holds true for the folder that is directly under the inbox.

    I don't know if this will work for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1