![]() |
#1
|
|||
|
|||
![]()
Hi everyone,
Macropod linked me this site and people seem to be really friendly here. I'm trying to use the SplitMergedDocument() function to split a bunch of word docs into pdf files however I wanted it to use a custom filename for each page either in some custom part of the MS word doc that doesn't appear on the page or referencing a specific column title name and in a specific sheet within an excel file. Can someone help? Thanks so much Here's the code to make it easier for anyone wanting to help ![]() Code:
Sub SplitMergedDocument() ' Sourced from: https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html Application.ScreenUpdating = False Dim i As Long, j As Long, k As Long, StrTxt As String Dim Rng As Range, Doc As Document, HdFt As HeaderFooter Const StrNoChr As String = """*./\:?|" j = InputBox("How many Section breaks are there per record?", "Split By Sections", 1) With ActiveDocument ' Process each Section For i = 1 To .Sections.Count - 1 Step j With .Sections(i) '***** ' Get the 1st paragraph's text StrTxt = Split(.Range.Paragraphs(1).Range.Text, vbCr)(0) For k = 1 To Len(StrNoChr) StrTxt = Replace(StrTxt, Mid(StrNoChr, k, 1), "_") Next ' Construct the destination file path & name StrTxt = ActiveDocument.Path & "\" & StrTxt '***** ' Get the whole Section Set Rng = .Range With Rng If j > 1 Then .MoveEnd wdSection, j - 1 'Contract the range to exclude the Section break .MoveEnd wdCharacter, -1 ' Copy the range .Copy End With End With ' Create the output document Set Doc = Documents.Add(Template:=ActiveDocument.AttachedTemplate.FullName, Visible:=False) With Doc ' Paste contents into the output document, preserving the formatting .Range.PasteAndFormat (wdFormatOriginalFormatting) ' Delete trailing paragraph breaks & page breaks at the end While .Characters.Last.Previous = vbCr Or .Characters.Last.Previous = Chr(12) .Characters.Last.Previous = vbNullString Wend ' Replicate the headers & footers For Each HdFt In Rng.Sections(j).Headers .Sections(j).Headers(HdFt.Index).Range.FormattedText = HdFt.Range.FormattedText Next For Each HdFt In Rng.Sections(j).Footers .Sections(j).Footers(HdFt.Index).Range.FormattedText = HdFt.Range.FormattedText Next ' Save & close the output document .SaveAs FileName:=StrTxt & ".docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False ' and/or: .SaveAs FileName:=StrTxt & ".pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False .Close SaveChanges:=False End With Next End With Set Rng = Nothing: Set Doc = Nothing Application.ScreenUpdating = True End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Style Sets Stopped Working on Custom Template after Recent Microsoft Update | CynthiaKPollard | Word | 6 | 12-20-2021 08:37 PM |
![]() |
Skyfawn | Mail Merge | 7 | 08-02-2021 02:45 AM |
filename field not displaying correct filename when that name starts with # | plrsmith | Word | 1 | 07-06-2018 03:10 AM |
![]() |
UnlimitedPower | Word VBA | 1 | 08-19-2016 12:22 AM |
Filename in footer | Dixon | Word | 3 | 09-24-2009 09:12 AM |