VBA for Outlook loop adjustment

  • Hi, I am struggling with creating a macro, which could be used in Outlook. Basically, I would like a macro to search through Inbox, Sent emails and all sub folders in order to search for attachments. In case there are some emails with attachments added, macro will move these emails to specific folder like "Attachments" in my Docs. Perhaps it will be also possible to add a filter to choose certain documents types? Sounds slightly difficult, but is it doable? Many thanks.


    Here's the code I am using right now. It's searching for all attachments in my Sub folders and uploading them into my Documents folder.


    Code
    1. Sub Test () [/COLOR]'Arg 1 = Folder name of folder inside your Inbox'Arg 2 = File extension, "" is every file'Arg 3 = Save folder, "C:\Users\Ron\test" or ""' If you use "" it will create a date/time stamped folder for you in your "Documents" folder' Note: If you use this "C:\Users\Ron\test" the folder must exist. 'SaveEmailAttachmentsToFolder "MyFolder", "pdf", "gif" SaveEmailAttachmentsToFolder "SOL", "", "" End Sub[COLOR=#333333]


    Code
    1. [/COLOR]Sub SaveEmailAttachmentsToFolder(OutlookFolderInInbox As String, _ ExtString As String, DestFolder As String) Dim ns As NameSpace Dim Inbox As MAPIFolder Dim SubFolder As MAPIFolder Dim Item As Object Dim Atmt As Attachment Dim FileName As String Dim MyDocPath As String Dim I As Integer Dim wsh As Object Dim fs As Object On Error GoTo ThisMacro_err Set ns = GetNamespace("MAPI") Set Inbox = ns.GetDefaultFolder(olFolderInbox) Set SubFolder = ns.GetDefaultFolder(olFolderInbox) I = 0 ' Check subfolder for messages and exit of none found If Inbox.Items.Count = 0 Then MsgBox "There are no messages in this folder : " & olFolderInbox, _ vbInformation, "Nothing Found" Set SubFolder = Nothing Set Inbox = Nothing Set ns = Nothing Exit Sub End If 'Create DestFolder if DestFolder = "" If DestFolder = "" Then Set wsh = CreateObject("WScript.Shell") Set fs = CreateObject("Scripting.FileSystemObject") MyDocPath = wsh.SpecialFolders.Item("mydocuments") DestFolder = MyDocPath & "\" & Format(Now, "dd-mmm-yyyy hh-mm-ss") If Not fs.FolderExists(DestFolder) Then fs.CreateFolder DestFolder End If End If If Right(DestFolder, 1) <> "\" Then DestFolder = DestFolder & "\" End If ' Check each message for attachments and extensions For Each Item In Inbox.Items For Each Atmt In Item.Attachments If LCase(Right(Atmt.FileName, Len(ExtString))) = LCase(ExtString) Then FileName = DestFolder & Item.SenderName & " " & Atmt.FileName Atmt.SaveAsFile FileName I = I + 1 End If Next Atmt Next Item ' Show this message when Finished If I > 0 Then MsgBox "You can find the files here : " _ & DestFolder, vbInformation, "Finished!" Else MsgBox "No attached files in your mail.", vbInformation, "Finished!" End If ' Clear memoryThisMacro_exit: Set SubFolder = Nothing Set Inbox = Nothing Set ns = Nothing Set fs = Nothing Set wsh = Nothing Exit Sub ' Error informationThisMacro_err: MsgBox "An unexpected error has occurred." _ & vbCrLf & "Please note and report the following information." _ & vbCrLf & "Macro Name: SaveEmailAttachmentsToFolder" _ & vbCrLf & "Error Number: " & Err.Number _ & vbCrLf & "Error Description: " & Err.Description _ , vbCritical, "Error!" Resume ThisMacro_exit End Sub[COLOR=#333333]


    [/COLOR]