How to save attachments from multiple e-mails at once

Posted on 2004-10-08
Medium Priority
Last Modified: 2010-04-08
I am receiveing hundreds of e-mails, each with one attachment. How can I save all of these attachments at one time vs. selecting each message individually and saving the attachments one-by-one?


Question by:mschonlau
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 30

Expert Comment

ID: 12261844
don't think you can do that
LVL 49

Accepted Solution

sunray_2003 earned 252 total points
ID: 12262630
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

LVL 30

Expert Comment

ID: 12265204
i stand corrected guys ;)

Expert Comment

ID: 12265291
Ooops.... maybe sunray_2003 and me were typing the same comment at the same time!
LVL 13

Assisted Solution

stefri earned 248 total points
ID: 12265422
If you are comfortable vith VBA or broke:
Open VBA Editor (Alt F11)
Expand Project1/MS Outlook Modem/ThisOutlookSession
Cut and Paste the code below in right pane

'------------snip start from here
' Save attachments from selected mails to a folder
' Stefri 10/09/2004 use at your own risks
Public Sub saveAllAttachtoDisk()

Dim objAtt As Outlook.Attachment

Dim saveFolder As String
Dim myOlExp As Outlook.Explorer
Dim myOlSel As Outlook.Selection
Dim itm As Object
Set myOlExp = Application.ActiveExplorer
Set myOlSel = myOlExp.Selection

    saveFolder = "c:\att\" '<<<<<<<<<<<<<< to be adapted to your need
    On Error Resume Next
    If myOlSel.Count > 0 Then
        For Each itm In myOlSel
            For Each objAtt In itm.Attachments
                objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName
                Set objAtt = Nothing
            Set itm = Nothing
    End If
    Set myOlExp  = Nothing
    Set myOlSel = Nothing
End Sub
'----------- snip ends here
Close VBA Editor
Check Tools/Macro/Security
Set to Medium

Close Outlook, accept to save the ProjectOtm
Start OL
Accept Macros to be enabled
Select mails with attachment using Shift/Ctrl Click
Select saveAllAttachtoDisk sub
That's it

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Suggested Courses

752 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