training excel vba - Zipped Files again

Hi Paula

the Office Developer Center might be of assistance here. Take a look at this section which details how to create an email with attachment.
https://msdn2.microsoft.com/en-us/library/aa210901 (office.11).aspx

Along the same lines you will see a discussion on msdn around the topic of creating compressed folders using vba.
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=692917& ;SiteID=1

I hope this is helpful.

Kind regards,

Andrew