Web Development

Ask something
Discussion Locked

Microsoft Access zip /protect attachment

0 helpful
3 replies

by steve.mallard

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When adding a command to email and specifying the format, can you zip and password the attachment.

code:
if form_myform.amount >0 then
dim stdocname as string
stdocname= "myreport"
docmd.openreport stdocname, acNormal
docmd.sendobject acreport, stdocname, acformatsnp, "myemail@email.com",,,"Subject", ,false
docmd.runsql "delete from mytable * where st='38'"
docmd.setwarnings true
docmd.domenuitem acformbar, acrecordsmenu, 5, acmenuver70

blah blah blah

3 replies

by zaferus

I'm not a great scripter, but I did have a similar issue. I needed to run an automated process that would refresh certain files inside a zip.

I used the command line zip utilities for this, and it works great. Stable and it has always been solid. If you purchase a copy if Winzip you get the cli zip tools. I would give them a try they can help you run the actual zip part quite easily (it has many parameters you can pass it).

-Z

by zaferus

I'm not a great scripter, but I did have a similar issue. I needed to run an automated process that would refresh certain files inside a zip.

I used the command line zip utilities for this, and it works great. Stable and it has always been solid. If you purchase a copy if Winzip you get the cli zip tools. I would give them a try they can help you run the actual zip part quite easily (it has many parameters you can pass it).

-Z

This discussion is closed to new replies.