Hi,
I have a macro which creates pdf files based on the information in the excel database for payroll. Each employee has 2 pdfs assigned. I have to assign password to these two pdf files before sending this through mail merge.
For each employee the password for both pdfs remains the same. These passwords are maintained in the above mentioned database.
I tried using winzip with macro but here the files are copied on to a new folder and then the folder is zipped and protected. Though this is one of the best ways but my employees are not comfortable with winzip. Hence need to send them the pdfs directly without zipping but with password protected.
Request you to please help with a possible solution or recommendation of a third party software.
Regards,
Vinod
This database also contains the passwords that have to be assigned to the indi
I have a macro which creates pdf files based on the information in the excel database for payroll. Each employee has 2 pdfs assigned. I have to assign password to these two pdf files before sending this through mail merge.
For each employee the password for both pdfs remains the same. These passwords are maintained in the above mentioned database.
I tried using winzip with macro but here the files are copied on to a new folder and then the folder is zipped and protected. Though this is one of the best ways but my employees are not comfortable with winzip. Hence need to send them the pdfs directly without zipping but with password protected.
Request you to please help with a possible solution or recommendation of a third party software.
Regards,
Vinod
This database also contains the passwords that have to be assigned to the indi