Mail Merge with Merged File Name in Footer

DM2 · #10 05-01-2019, 03:15 PM

Quote:

added a line of VBA code to the example

Paul,
I think you're talking about the below code, which I think is new under the heading "
Send Mailmerge Output to Individual Files"?

Code:

      With ActiveDocument
        'Add the name to the footer
        '.Sections(1).Footers(wdHeaderFooterPrimary).Range.InsertBefore StrName
        .SaveAs FileName:=StrFolder & StrName & ".docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False
        ' and/or:
        .SaveAs FileName:=StrFolder & StrName & ".pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False
        .Close SaveChanges:=False
      End With

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
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 is Deleting objects in my header and footer during the merge	bgranzow	Mail Merge	9	06-05-2015 05:03 AM
how do i ad a specific pdf file to a mail merge?	mseibel	Mail Merge	1	08-28-2012 07:53 PM