+ Reply to Thread
Results 1 to 7 of 7

Need VBA code to pull attachment save files update in active sheet depn upon subject line

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need VBA code to pull attachment save files update in active sheet depn upon subject line

    Dear experts

    i have bulk email from verticals team around 80 to 90 mails a day, i need to save files one by one from mail and need to check each sheets in attachment

    i spend alot of time in it, i need vba code to pull attachment from mail and save those file in particular path file

    Subject :Network Activity Reports depends upon the subject by today date,it has to pull files from mail and save to folder by macro
    those data need to map in sheet can find who not sending till then.
    A: Date
    B:Email which who send the file
    C:Subject line
    D:File Name of attachment.
    From E list out sheet names
    some people send 2 attachment, fill map in next row
    some people hide the sheet in workbook. or protect password in case ,leave the file to maponly file names enough

    fidn the attachment

    thanks and regards
    Attached Files Attached Files

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

    Re: Need VBA code to pull attachment save files update in active sheet depn upon subject

    Check out this article to see if it will work for you.

    https://www.excelforum.com/tips-and-...ml#post4796524
    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
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA code to pull attachment save files update in active sheet depn upon subject

    Its work but need to assign folder and file name in field than only it download. i am zero knowledge of code

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA code to pull attachment save files update in active sheet depn upon subject

    any experts help on this?

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

    Re: Need VBA code to pull attachment save files update in active sheet depn upon subject

    Do you know how to make a filter rule in Outlook to assign emails to folders based on the wording in the subject line?

    Did you understand the instructions in the word document that explains how to fill out the table with the mailbox name, folder names (outlook), directory names (path to where you want the attachments downloaded) and File types to download?

    The application is set up to do all this without having to code anything. It is literally a "fill in the blanks" exercise.

  6. #6
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA code to pull attachment save files update in active sheet depn upon subject

    i want add column updates for Date,Email,workbook Name and No of sheet ,
    Attached Files Attached Files
    Last edited by breadwinner; 12-18-2022 at 04:55 PM. Reason: file missing

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

    Re: Need VBA code to pull attachment save files update in active sheet depn upon subject

    Without a sample workbook, I can go no further. I still do not understand your requirement.

    First you set up Outlook with subfolders directly under the inbox. The documentation I have sets it up, using as an example, the project names I was tracking when I made up the example. You may have as many subfolders as you need. In my case I had three projects I was tracking. I also set up a dummy project for the purposes of testing. Under each one of the subfolders, set up another folder named Processed. The mail is moved to this folder when it is processed so you don't process the mail more than once.

    THEN set up a filter rule in Outlook to reroute incoming email to the appropriate subfolders based subject, from or whatever determines where the mail should go.

    Then open the application. In the Mailbox cell enter in the name of the mailbox to which the mail is delivered. In my case it was a common mailbox called Labor Analysis. Typically it could be [email protected].

    Fill out the Table in Columns K:N.
    • Column K contains the name of the subfolders
    • Column L contains the name of the subfolder to this folder. This is where mail that has already been processed will be moved.
    • Column M contains the full path name on the network or hard drive where you want the attachments to be saved.
    • Column N contains the attachments you want downloaded. For example: *.xl* will get all Excel attachments. If you have more than one type separate them with a comma such as *.xl*,*.pdf which will get you all Excel files and all PDFs. You can be even more creative with the wildcards. For example Status Report ??-??-????.xlsx will get files like Status Report 12-19-2022.xlsx.

    Now back to the top left of the control panel. Once you fill in the Mailbox, it is good "forever." You can process one subfolder at a time. The green shaded cell, B3, contains a drop down list of all the subfolders that you set up in the table in columns K:N. Select one of them. Do not touch anything else. The rest of the information in Column B is filled in automatically when a selection is made in cell B3.

    Then click on the Read Mail button. The process is automatic from there.

+ 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] Download attachment and rename with subject line
    By ali84pk in forum Outlook Programming / VBA / Macros
    Replies: 11
    Last Post: 07-25-2023, 12:01 PM
  2. [SOLVED] VBA - Email subject line to pull date from cell on Sheet
    By Rosco88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2018, 05:09 AM
  3. Modify VBA to save attachment with Subject line as file name??
    By dwhite30518 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 02-27-2017, 11:32 AM
  4. Outlook Macro to save mail attachment from a specific sender with subject line
    By manoj.0790 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2016, 09:34 AM
  5. Save outlook attachments and rename/append files with identifier from subject line
    By XLnExcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2015, 12:49 PM
  6. Download Attachment and Rename With Subject Line v2
    By CBJason in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2014, 04:33 PM
  7. [SOLVED] Adjust code to pull excel data in subject line
    By maxutility in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2012, 04:19 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