Ivan Moala has a script that zips and emails files. Perhaps you can use part
of that code. Find it he
http://www.xcelfiles.com/Outlook_02.html

HTH,
Matthew Pfluger

"Arvind Mahto" wrote:

Hi, All,
I am on a project where i want to zip an excel fil using macro. Is it
possible. If yes, please let me knoe the coding.

Your suggestion would be very valuable for me.