Save files from emails in a Personal Folder automatically to a local C drive folder

Posted on 2004-11-16
Last Modified: 2010-04-08
Hi Experts!

I'm wondering if there is a script that can do this automatically. I would appreciate your help very very much, it would save a lot of manual work on copying and saving files.

I am getting emails containing data for a project into a special folder in Outlook Personal Folders, called Data. Is there a way to save the Excel attachement from each of these emails into C:\Data? I only need the Excel file, not the text of the email or any other attachements.

Any idea if this is possible?

Thank you very much!
Question by:amoyes
    LVL 49

    Accepted Solution

    Are you familiar with vba and if yes , check this


    Author Comment

    Hi Sunray!

    This code looks like what I need. Where do I put it though and how do I run it? Is it automatic or do I have to run it?

    LVL 49

    Expert Comment

    I am really not that much familiar how to run code. i think you can do this
    open outlook
    press Alt + F11 to open macro editor
    create a new project and paste this code there and run it

    let me know if you cannot continue from there

    Author Comment

    HI Sunray,

    I pasted the code in a module. When I try to run, there is no macro name in the list. I should have a sub to run and I don't know what that should be like. Can you help with step by step instructions on where to change the folder path, the Outlook library and how to run the code? I don't know what the declarations are to be used for either.

    I am somewhat confused, I would appreciate more help.


    Author Comment

    Hi Sunray,

    Thanks for your solution. I apologize it took me so long to respond. It took a lot of testing to implement this solution.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Sorry for my English and Italian screenshots..... Problem: Every Year the number of E-Mails grow dramatically and the space that they take on Exchange Servers or .PST files, grow much more faster, once it was only text, now our E-Mail Archives …
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now