Office 2013



Hi

I've seen several bits of code for saving and renaming attachments in Outlook but I can't get them to work for me

Reason is that I need VBA code to extract and rename files sent as a zip file attachment

For example, if I have a file called "FromCompanyA.zip" which contains a xls file called 01222.xls, I need this xls file renamed as yyyy-mm-dd_CompanyA.xls format

(yyyy-mm-dd is the creation date of the file name)


Zip files saved to eg C:\ZipFilesreceived
Renamed extracted files saved to C:\RenamedExtracts

Can you help me by supplying code?

Many thanks

Andy