+ Reply to Thread
Results 1 to 2 of 2

Find attachment and open in shared mailbox

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    8

    Find attachment and open in shared mailbox

    Hi Guru's
    I am trying to look through a shared outlook mailbox for emails containing a file named 'new details.xlsx'. there will be multiples so I need to check all mail items and then move those that contain a the file into a separate folder named 'processed'. Open the mail attachments so I can combine into a single file to be uploaded.
    I don't currently have sample code as I just got the problem and my outlook knowledge is lacking
    thanks in advance

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

    Re: Find attachment and open in shared mailbox

    This might not be exactly what you are looking for, but it is close. It reads all the files in the specified mailbox folder, extracts the attachments to the specified excel folder and moves the email to the processed subfolder. You may have to modify it a bit so it only only takes action when the attachment matches the name you are looking for and then, since you will have duplicate names, save the attachment with a counter stamp (E.g. new details-1.xlsx, new details-2.xlsx, etc.

    Then either in a separate application (as I use it) or as a continuation of the application, combine these saved files.
    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)

Similar Threads

  1. Send Meeting Request from Shared Mailbox
    By orhanceliloglu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2020, 08:59 AM
  2. Save mails sent from shared mailbox in that shared mailbox's Sent folder
    By LordClick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2016, 03:30 PM
  3. Outlook 2010 VBA Code to open a link from an unread mail in a Shared Mailbox
    By MHamid in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2015, 03:46 PM
  4. Open newest unread email in shared mailbox
    By Aaron092 in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2014, 04:04 PM
  5. Sending email from a shared mailbox
    By badlydrunkboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2014, 10:12 AM
  6. [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
  7. Reference shared Outlook mailbox
    By arneld in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2012, 08:29 PM

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