General discussion

Locked

Microsoft Access zip /protect attachment

By steve.mallard ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by zaferus In reply to Microsoft Access zip /pro ...

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

Collapse -

by zaferus In reply to Microsoft Access zip /pro ...

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

Collapse -

by zaferus In reply to

Sorry for the dual post - accidentally double clicked the submit button...

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums