How to Zip Files from ms Access

[h.khalid11]

Dear all,

I have files in my computers and now want zip that files and send it by
email any one help me thanks
Khalid

[salad]

h.********@gmail.com wrote:

Dear all,

I have files in my computers and now want zip that files and send it by
email any one help me thanks
Khalid

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

[salad]

h.********@gmail.com wrote:

Dear all,

I have files in my computers and now want zip that files and send it by
email any one help me thanks
Khalid

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.

[paii, Ron]

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.

<h.********@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Dear all,

I have files in my computers and now want zip that files and send it by
email any one help me thanks
Khalid

[John Mishefske]

h.********@gmail.com wrote:

Dear all,

I have files in my computers and now want zip that files and send it by
email any one help me thanks

Another option is the CGZibLibrary.DLL

http://www.codeguru.com/vb/gen/vb_gr...icle.php/c6743

--
'---------------
'John Mishefske
'---------------

[Benny Andersen]

On Mon, 12 Dec 2005 07:58:43 -0600, "paii, Ron" <pa**@packairinc.com>
wrote:

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") You could get trouble with access going to step 3 before winzip has
finished. Terry Kraft has made a shellwait funktion:
http://www.mvps.org/access/api/api0004.htm
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.

--
Mvh Benny Andersen