How can I send password protected files by email using VBA from MS Access
Posted on 2014-10-27
There is a business requirement to extract data to be loaded into MYOB at another, remote office. I have coded the extract (from an SQL 2008 database) which creates three files on a local computer.
I would like to Zip these flies, password protect them and send them to the remote office. The data is in the form of a csv file. It is not very large, so Zipping is not essential. The data is not hypersensitive, but commercial in confidence. The office staff need to perform this at close of business, so I would like to automate the process. But if anybody has a suggestion for using zip, I could make this a two button operation
Extract the three files to the desktop
Zip, password protect and email the files as an attachment