Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-01-2019, 04:28 AM
DM2 DM2 is offline Mail Merge with Merged File Name in Footer Windows 7 64bit Mail Merge with Merged File Name in Footer Office 2010
Novice
Mail Merge with Merged File Name in Footer
 
Join Date: Apr 2019
Posts: 5
DM2 is on a distinguished road
Default


Quote:
If the aim is to add the filename to the footer then you can get the name of the document (not the PDF file) with
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.
Reply With Quote
  #2  
Old 05-01-2019, 05:30 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge with Merged File Name in Footer Windows 10 Mail Merge with Merged File Name in Footer Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
showing mail merge all in one file lezawang Mail Merge 3 05-24-2018 03:10 PM
Mail Merge with Merged File Name in Footer Log file for mail merge neilclelland Mail Merge 7 12-08-2016 03:08 PM
some records disappear after emailing mail merged file Dr Ennui Mail Merge 1 06-10-2015 04:17 PM
Mail Merge with Merged File Name in Footer Mail Merge is Deleting objects in my header and footer during the merge bgranzow Mail Merge 9 06-05-2015 05:03 AM
Mail Merge with Merged File Name in Footer how do i ad a specific pdf file to a mail merge? mseibel Mail Merge 1 08-28-2012 07:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft