Processing multiple emails
August 25, 2008 • JP • No Comments • Rate This Article
In Highlight And Move Multiple Emails, I demonstrated a technique for processing several emails at once and moving them to another folder. Here is another example that shows how you can save attachments from several selected emails, then delete them.
Dim Msg As Outlook.MailItem
Dim MsgColl As Object
Dim MsgAttach As Outlook.Attachments
Dim i As Long
Dim FileN As String
Dim lAttach As Long
On Error Resume Next
Set MsgColl = ActiveExplorer.Selection
On Error GoTo 0
If Not MsgColl Is Nothing Then
For i = 1 To MsgColl.Count
' loop through selected items and save all attachments from each of them
Set Msg = MsgColl.Item(i)
Set MsgAttach = Msg.Attachments
For lAttach = 1 To MsgAttach.Count
FileN = MsgAttach.Item(lAttach).DisplayName
MsgAttach.Item(lAttach).SaveAsFile "C:\My Folder\" & FileN
Next lAttach
Next i
If MsgBox("Would you like to delete the selected emails now?", _
vbInformation + vbYesNo) = vbYes Then
For i = 1 To MsgColl.Count
Set Msg = MsgColl.Item(i)
Msg.Delete
Next i
End If
Else
GoTo ExitProc
End If
ExitProc:
Set MsgAttach = Nothing
Set Msg = Nothing
Set MsgColl = Nothing
End Sub
Other things you can do involve incorporating other email properties, such as received time. This will save the filename with date and time pre-pended to the display name:
And this will save the filename as just the received time, with the proper file extension:
You can also use the Subject property:
This will set the attachment filename to Subject and Received time.
Enjoy,
JP
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Excel, I choose you!
Next Post: Add your signature to pre-formatted emails
Speak Your Mind
Tell us what you're thinking...Certain comments (including first-time comments) are subject to moderation and will not appear immediately. Please view the Comment Policy for more information. To post VBA code in your comment, use tags like this: [cc lang='vb']Code goes here[/cc].