View Single Post
 
Old 05-01-2019, 05:30 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Quote:
Originally Posted by DM2 View Post
Graham...The aim is to place the output file name in the footer. Based on your comment it doesn't appear as the addin can add the field that holds the output file name (<<filename>>) to the output PDF.

I noticed that when the <<filename>> field is in the body of the mail merge document, the macro you provided, does it's job on the output word document. I also noted that if the <<filename>> is placed in the footer, the macro does NOT add the file name to the output word document.

In both cases the <<filename>> doesn't make it to the PDF as you mentioned.
The macro adds the field to the document before it is saved and the field will reflect the name of the document. The document is then saved as PDF and the filename in that PDF will be the filename of the Document, i.e. it will have the DOCX extension and not PDF. This will be the same for any document with a filename field and that document is saved as PDF.

The macro inserts a filename field in the footer of the created documents. Any pre-existing filename field in the footer from the merge document will not reflect the names of the documents after the merge and should be removed before running the merge.

The process assumes that you are using the current version of the add-in and that you have entered the macro name on the macro tab.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote