asked on

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

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!
Andreea

ASKER CERTIFIED SOLUTION

sunray_2003

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

amoyes

ASKER

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?

Thanks!
Andreea

sunray_2003

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

amoyes

ASKER

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.

Thanks!
Andreea

amoyes

ASKER

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.

regards,
Andreea