Microsoft Access zip /protect attachment - TechRepublic
General discussion
November 21, 2005 at 03:09 PM
steve.mallard

Microsoft Access zip /protect attachment

by steve.mallard . Updated 20 years, 7 months ago

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 discussion is locked

All Comments