Extract zip file from Outlook

rollingzep

Board Regular
Joined
Nov 18, 2013
Messages
215
Office Version
  1. 365
Platform
  1. Windows
Hi,

<p>

I receive a zip file in my Outlook inbox which contains few csv files.
From my main workbook, Is it possible to get this zip file, unzip and extract the csv files to a specific folder?
I can then import them to my workbook for my other work.

The subject of the email is same except that the date is the previous working day (BO /2022-07-05) and the zip file is also similarly the previous day
as in 2022-07-05.zip
</p>
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,217,372
Messages
6,136,182
Members
449,996
Latest member
duraichandra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top