By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

How to Zip Files from ms Access

P: n/a
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

Dec 11 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.
Dec 11 '05 #2

P: n/a
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.
Dec 11 '05 #3

P: n/a
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

Dec 12 '05 #4

P: n/a
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
'---------------
Dec 14 '05 #5

P: n/a
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
Dec 14 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.