#1
|
|||
|
|||
Password protect individual files after merge
Hi, Been using the Merge to individual files macro, which is great.
I am a complete novice and was hoping to be able to add password protect option to the individual files either as a Word doc or PDF. Been searching for some code to add to the macro to do protect files but having no luck Thank you in advance for your help! |
#2
|
||||
|
||||
Word cannot apply protection to a PDF.
What kind of protection do you want to apply to the document: • a password to open? • a password to edit? something else?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Both my merge splitting add-ins Individual merge letters. and Merge and Split will merge to PDF and allow you to set a common password (I am working on a version of the former that will allow you to set individual passwords from the merge data source, but it will not be ready for a while).
The process requires the addition of (free) third party software PDFCreator 2.5.2 which is also linked from the web page. Anecdotal evidence suggests that it will also work with the more recent and more bloated version of the PDFCreator software, but I haven't tested it and recommend instead the version 2.5.2.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#4
|
|||
|
|||
Hi Paul, I was hoping for a password to open the file please. Thank you in advance!
|
#5
|
||||
|
||||
Simply change:
Code:
.SaveAs FileName:=StrFolder & StrName & ".docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False Code:
.SaveAs FileName:=StrFolder & StrName & ".docx", FileFormat:=wdFormatXMLDocument, Password:="drowssap", AddToRecentFiles:=False
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge to individual files, there's any kind of progress indicator | eduzs | Word VBA | 3 | 08-31-2018 08:46 PM |
Password protect notebook | Lela33 | OneNote | 0 | 11-24-2017 09:09 AM |
Mail Merge To Individual PDF Files | iamrickdeans | Mail Merge | 1 | 01-15-2014 12:46 AM |
Here!! Help me to remove password protect from pdf | priya | Word | 1 | 09-17-2011 10:35 AM |
How can I protect all my MSW documents with a password ? | Antonio Machado | Word | 0 | 07-05-2010 07:55 PM |