Hello...

I utilize several reports that contain sensitive personal information about an employee. I want to email the saved PDF to certain executives.

I found the code below in one of the forums.

DoCmd.OutputTo acOutputReport, "anyreport", acFormatPDF, "c:\myfile.pdf", False

Does anyone know if it is possible to password protect the file using VBA? A buddy suggested I create a zip file with a password using VBA and then email the zip file.

Thanks,

Hi !!!



You can password the PDF itself on the menu bar File>Properties then follow the prompts

I think you are going to have to use the pdf API reference if you want this done automatically. I had previously needed to do some pdf manipulation and downloaded in July 2009, “acrobat_pdfl_api_reference.pdf" from adobe but cannot find it anymore, there are several other API references I was able to find currently. Icouldnt attach it, it is 44MB. I have to admit that when I was dealing with the references I got most of what I wanted, but not password because I found the reference hard to understand: what it did, what could be used and how, but I was not schooled in their thoughts.

Hope that is a starting point and if you get vba code for it, please post.