General discussion

  • Creator
    Topic
  • #2178259

    Microsoft Access zip /protect attachment

    Locked

    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

All Comments

  • Author
    Replies
    • #3123328

      Reply To: Microsoft Access zip /protect attachment

      by zaferus ·

      In reply to Microsoft Access zip /protect attachment

      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

    • #3123327

      Reply To: Microsoft Access zip /protect attachment

      by zaferus ·

      In reply to Microsoft Access zip /protect attachment

      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

Viewing 1 reply thread