Want to ZIP and Email the current workbook

[a006dean]

Anyone ever work out a technique to ZIP the currently open workbook and attach it to an email? The WinZip software has this functionality if you do a right-click in Explorer but I can't find any notes about command options to trigger the mail of a zip file.

 

[a006dean]

I was wondering about that "send". I did the "display" and hit the SEND button but that evidently doesn't quite do it.

On the other hand, I'm thinking that doing the "display" and the "send" sends it twice. I'll have to experiment but nonetheless, this is not my preference.