Save attachments to a file outside of Outlook

**cmorten82** · 02-21-2018, 12:41 PM

I receive an email daily with an attachment that I have to take and save to a specific file location. Is it possible to have VBA run in outlook to look for a specific attachment and save the attachment to that specific file location. The file is named the exact same thing each day so when it saved it would overwrite the existing file. Not sure if it matters but this is for work and I am on a file share server so multiple people have access to this location which I am fine with just not sure if that will effect the code or if I have to save it to a local file instead.

**dflak** · 02-21-2018, 02:51 PM

I have something that does this on an "industrial Scale."

Create a folder directly under the inbox of the mailbox to read. In the example I have a shared mailbox called Labor Analysis - if it's a personal mailbox, it will be the name of that mailbox whatever it is.

Create a rule to move the mail in question into this folder.

Create a subfolder to this folder.

On the Control Panel on this sheet, fill in the mailbox name where indicated. Also fill out the table - the table tells the program which main folder (directly under inbox) you want to use and to which subfolder you want to move it after processing it. The third column tells the program what windows network folder to move the mail to and the fourth column tells the program what kind of attachments to download. You can use any wildcard commands known to the LIKE command in VBA. If not pattern is provided, then the mail is moved an no attachments are downloaded.

You can use this utility to manage a number of main folders in the same mailbox.

When you select a main folder, the program pulls the right information and the program is ready to process mail.

The program will loop through all the mail in the main folder, download the atachments, move the mail to the subfolder (so it does not get processed again) and marks it as read.

Documentation is included.