Macro to attach Zip Files within sub-folders

[Howardc1001]

I have code to attach zip files within sub-folders with C:\Sales Reports in Microsoft outlook



The code works well and attaches some of the zip files in Outlook as the maximum limit is 20MB




I need my code amended to attach up to a max limit of 20MB and when this is reached to create a second to attach the balance of the zip files (the total off al the Zip files is less than 40MB so I only need two emails)


Your assistance in this regard is most appreciated

Please Login or Register  to view this content.

I have also posted on https://www.myonlinetraininghub.com/...folders#p18655

[Howardc1001]

There are 18 Zip files within the sub-folders

As an alternative to my request is to attach the first 10 files to the first email and the balance to the second email

[Howardc1001]

See solution https://www.myonlinetraininghub.com/...folders#p18718