VBA CODE Required

[sifat]

Hi sir , I used VBA code in word file for mail-merge. In this VBA i prepared 10 increment letter of 10 employees in PDF file.
Now I want a VBA CODE in which i will protect these PDF files with a unique password for each employee increment latter and then send these protected PDF file to each employee on his email address.
Can you provide me VBA Code for it. Waiting For your cool response Thanks in advance

 

[Peter_SSs]

Welcome to the MrExcel board!

I used VBA code in word file for mail-merge.

It appears that you are asking for Word vba code so I am moving this out of the 'Excel Questions forum.

 

[Macropod]

MS Office has no VBA capacity for adding password protection to PDFs.

 

[sifat]

MS Office has no VBA capacity for adding password protection to PDFs.

Ok can without password we can attach and send through VBA to multiple persons ?

 

[Macropod]

There are plenty of examples on the web for how to do that. See, for example:

Mail Merge to E-mail with Attachments

and the Merge Tools Add-in at:

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

onedrive.live.com

 

[sifat]

MS Office has no VBA capacity for adding password protection to PDFs.

I watched a video on youtube a man did this by excel he given pdf file a password and then send these file to different person. I am attaching link of that video. When you free kindly let me know i am waiting for your kind reply.