Outlook VBA: Move/Copy nested PDF files in attached emails to folder on desktop.

[marame]

I regularly receive one email that has 50 or more emails attached to it. Each of those attached emails in turn has a PDF file attached to it. It is extremely time consuming to open the primary email, then open each individual attached email, then drag/copy each nested PDF file to a desktop folder.

Could someone kindly post VBA code that will copy all nested file attachments from the attached emails to a desktop folder. I have tried to adapt various code I've found but so far I am not getting anywhere.

[PaulAJ4]

Hi, I had the exact same problem and noticed that no one had answered you here, so when I figured out a solution, I figured I'd share it. For this to work, you'll have to copy and paste all the attached emails to a dedicated folder in your Outlook. Then, when you run the macro, it will prompt you to select a folder, and you just select whatever folder you put them in. You should make sure the folder only contains the emails you want to run the macro on, as it will run on every message in the folder. Make sure to put the path of the folder where you want your files to go in "quotes" after the equal sign in the macro before running it. This is also set up to save the attachment as a .pdf with its original name.

Sub SaveAttachments()
    Dim Inb As Folder
    Dim Msg As MailItem
    Dim Att As Attachment
    Dim Name As String
    Dim Path As String
    
    Set Inb = Outlook.Session.PickFolder
    Path = 
    
    On Error Resume Next
    For Each Msg In Inb.Items
        For Each Att In Msg.Attachments
            Name = Att.FileName
            Att.SaveAsFile Path & Name & ".pdf"
        Next Att
    Next Msg
End Sub

[Weevr123]

I am having the same problem but i cant use macros is there a way to do this with out using a macro.

Hi, I had the exact same problem and noticed that no one had answered you here, so when I figured out a solution, I figured I'd share it. For this to work, you'll have to copy and paste all the attached emails to a dedicated folder in your Outlook. Then, when you run the macro, it will prompt you to select a folder, and you just select whatever folder you put them in. You should make sure the folder only contains the emails you want to run the macro on, as it will run on every message in the folder. Make sure to put the path of the folder where you want your files to go in "quotes" after the equal sign in the macro before running it. This is also set up to save the attachment as a .pdf with its original name.

Sub SaveAttachments()
    Dim Inb As Folder
    Dim Msg As MailItem
    Dim Att As Attachment
    Dim Name As String
    Dim Path As String
    Set Inb = Outlook.Session.PickFolder
    Path = 
    On Error Resume Next
    For Each Msg In Inb.Items
        For Each Att In Msg.Attachments
            Name = Att.FileName
            Att.SaveAsFile Path & Name & ".pdf"
        Next Att
    Next Msg
End Sub