Hey everyone,

I have been working on a macro that crawls through my Outlook to find a specified attached item, defined in my template workbook's sheet "Summary", temporarily save the attachment, copy the contents to a template workbook's sheet "Data", and then delete the temporary file. This has been working just fine with the attachments in .csv, up until I have come across attachments that are sent as a .zip due to file size.

I am essentially struggling with figuring out how to keep the exact same process, in addition to decompressing the .zip when the attachment is compressed. Searching the web for this has yielded different methods for decompression, but when trying to fit that in to my code, nothing works. I'm not too hot with vba, and I feel this is pretty advanced, so I appreciate any help or guidance on this.

This is what my code looks like:

Please Login or Register  to view this content.
Thanks in advance for any help, much appreciated!