Delete Multiple Outlook Attachments and Create Log

  • I have taken this code from online somewhere and cannot remember where.


    I have way too many emails at work and because of the system set up, I am limited in what I can create to archive older emails.


    I don't want to delete any emails but thought that I could reduce the size of my mailbox by removing all attachments over a certain size, saving them in one location and creating a log of where each attachment came from so that I can easily reference back (as to the best of my knowledge when you remove an attachment it removes all trace of it from the email).


    I have read online that you can use a rule to do this but it doesn't seem possible on my work system. I am also using Outlook 2010.


    So far, this is the code that I am using. The code itself works in that it copies all attachments from the selected emails and saves them in my chosen folder. However, it only deletes the attachments from the first email that it cycles through- not all of the emails. It even works if the first email has 1 or multiple attachments but as soon as it loops to the second email, it stops deleting the attachments.


    Aware that I can probably do something more elegant to create the audit log so any advice on that would also be appreciated.


    Thank you in advance


    Tom