+ 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
    134

    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
    365
    Posts
    7,919

    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
    134

    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
    365
    Posts
    7,919

    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)

Similar Threads

  1. Paste in order selected
    By Kapten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2016, 07:02 AM
  2. Send multiple emails with different attachments if attachments found
    By AnkitJain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2015, 05:35 AM
  3. Macro to Print all attachments across multiple emails in Outlook folder then delete email
    By Melissa Camp in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2015, 05:45 PM
  4. Copy Selected Objects from Excel to Outlook as Word Document Attachments
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2015, 08:01 AM
  5. Copy all emails in outlook folder and paste them in similar system folder and ms access
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2014, 07:31 AM
  6. Unarchive Enterprise Vault emails with VBA and copy to a local folder
    By ahs004 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2014, 11:40 AM
  7. [SOLVED] copy emails from outlook into a folder
    By plans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2014, 02:26 PM

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