+ Reply to Thread
Results 1 to 2 of 2

Read MailBox folder, download attachment from message, move message to subfolder

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

    Read MailBox folder, download attachment from message, move message to subfolder

    I have a common mailbox to which people mail reports that I need to parse to extract data.

    I have Outlook Filter Rules that parcel out incoming mail into Folders named for the type of report they are, (E,g, "Daily Ops Report" or "Budget Report").

    Enter the name of the mailbox in cell B1. Enter the name of the sub-folder (Processed) in Cell B5.

    Fill out the name of the mail folders in Column K (Daily Ops Report, Budget Report, etc.)

    Enter the Excel Path to which you want to download the attachments in Column L.

    Enter in whether the messages in the folder have attachments to download.

    Select the folder to process in Cell B11 and click on the Read Mail Button.
    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.

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

    Re: Read MailBox folder, download attachment from message, move message to subfolder

    Here is an improved version of the program. It allows you to specify what kind of attachments to be downloaded.
    Attached Files Attached Files
    Last edited by dflak; 05-30-2018 at 12:20 PM.

+ 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. Macro to take count of emails in each folder and subfolder from outlook mailbox
    By saurabhlotankar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2017, 01:33 AM
  2. find list of files in different subfolder and move them to one folder
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 05:35 AM
  3. [SOLVED] Show newl message envelop notification for all mailbox/shared mailbox added in outlook
    By Goku in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 07-04-2014, 01:23 PM
  4. Moving an e-mail from a subfolder in Mailbox to the equivalent subfolder in an archive PST
    By johncassell in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 11:31 AM
  5. Move Inbox Subfolder Items by Category to Folder
    By ker9 in forum Outlook Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2011, 02:03 PM
  6. Outlook, print pdf Save Attachment, Move Email To A Subfolder
    By stephen1000 in forum Outlook Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2009, 07:18 PM
  7. Opening an attachment of a message that has a message as attachmen
    By vetron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2006, 02:20 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