Outlook VBA - How to unzip content

Question

Background: I have a script that iterates through emails (without any emails being selected) in an Outlook folder saving their attachments to the desktop.

Issue: The attachment is a zip-file and I wonder if it is possible to save the decompressed file within (an .xls file) to the desktop instead?

Thank You!

http://www.rondebruin.nl/win/s7/win002.htm – Tim Williams Oct 10 '15 at 17:22 — Tim Williams, Oct 10 '15 at 17:22

score 0 · Accepted Answer · edited May 23 '17 at 10:34

0

The Outlook object model doesn't provide any method for that. You need to save the attached file on the disk and then unzip it programmatically.

If you try to use any search engine you can find the following links with a sample code:

edited May 23 '17 at 10:34

Community

1
1

answered Oct 10 '15 at 20:18

Eugene Astafiev

47,483
3
24
45

Outlook VBA - How to unzip content

1 Answers1