[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2004-11-16
Medium Priority
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
  • 3
  • 2
LVL 49

Accepted Solution

sunray_2003 earned 800 total points
ID: 12598856
Are you familiar with vba and if yes , check this


Author Comment

ID: 12625238
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

ID: 12625249
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

ID: 12657934
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

ID: 12778940
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.


Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

873 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