+ Reply to Thread
Results 1 to 3 of 3

Saving attachments in multiple emails in outlook 365

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    191

    Saving attachments in multiple emails in outlook 365

    Hi, we just started a big project and my team leaders are sending in reports. The reports are attachments to an email. I know I can select one email and choose to save all attachments. But, with a couple of hundreds emails all with one or two attachments that is going to be a time suck. I tried selecting multiple emails and there's no option to save all the attachments.

    Does anyone have a workaround?
    Macros don't scare me either. I'm ok with Excel macros so I figure I have a shot at learning Outlook Macros...

    Thanks for looking.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Saving attachments in multiple emails in outlook 365

    I had to do this in a prior job, here is the code I used.

    This code reads an incoming subfolder directly under the INBOX, strips out the attachments to the specified Excel folder and then moves the mail to a processed folder that is directly under the subfolder

    Set up the parameters as named ranges. Look at the initialize variables section to get the names.

    The only thing that should need explanation is KeepFiles. It defines what kind of files you want to download separated by columns. So *.xlsx,*.csv will download XLSX files and CVS files if any but not PDF, JPEG or other types of files.

    Please Login or Register  to view this content.
    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
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    191

    Re: Saving attachments in multiple emails in outlook 365

    That looks like just the ticket. Thank 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. [SOLVED] Outlook emails pulling attachments from Sharepoint
    By Seth_ in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-01-2019, 07:33 AM
  2. Macros to send multiple attachments to multiple emails in Outlook
    By melvern28 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2018, 07:44 AM
  3. [SOLVED] Excel Macro to Send Multiple Emails w/ Attachments using MS Outlook 2007
    By arnel_10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2017, 08:09 PM
  4. 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
  5. 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
  6. Accessing Outlook Attachments from Saved Emails
    By crunchKH in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 12:38 AM

Tags for this Thread

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