Hi all,

I need help creating password protected pdf’s using vba.

Ideally, the passwords would each have to be unique using info from an excel spreadsheet (ie concatenation of date of birth and postcode etc).

My aim is to automatically generate emails, with the pdf’s as attachment using a macro in excel.

This is what I have done so far:

1. Created a vba in a word doc that fetches info from the excel spreadsheet
a. Run the macro so that it creates the pdf’s

2. Then I go to the same excel spreadsheet and run a macro that generates emails in outlook with the attached pdfs.

All I need now is to have a code that makes the pdfs password protected, ideally unique.

I have trawled through the internet, but haven’t had any luck in funding anyone that has automatically created password protected pdfs.

I’m running on Adobe Acrobat DC and MS 16.

I would be very appreciative of your help.

Thanks,

Canning