You might want to check out the Shell() function.

Hmmmm... the shell function will help you in zipping a file.  Sending it
via e-mail is a another problem.

You might want to check out Tony Toews web site for the Email Faq.
http://www.granite.ab.ca/accsmstr.htm or
http://www.granite.ab.ca/access/email.htm

Next, you might want to go to
http://www.google.com/advanced_search?hl=en and enter something like
"Send Email Attachments" in the word search and *access* for the group.

Access allows you to send stuff via e-mail with the SendObject()
function but the objects sent are strictly Access objects.  No
attachments allowed.  So you need another method.

I create and email zip files using a multi step process.

1) Create a text file listing the path and file names to zip
2) Use the following shell command to zip using WinZip

   Shell("c:\program files\winzip\winzip32 -min -a paths.zip @paths.txt")

   Note: go to the winzip site for command line options

3) Create email attaching the zip file
    You will need to add some form of pause between the shell
     and attach functions to give WinZip time to create the file.

Another option is the CGZibLibrary.DLL

 http://www.codeguru.com/vb/gen/vb_graphics/fileformats/article.php/c6743