+ Reply to Thread
Results 1 to 1 of 1

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
    2013 / 2016
    Posts
    4,390

    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.

+ 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