Document Generation

How to Automate School Certificates and Student Letters

Turn one reviewed student case into a coordinated certificate-and-letter pack from several approved Word templates.

One student case
Several templates
Controlled signatures
DOCX + PDF
This is Contractor logic: one case, shared data, several different documents—not a roster-wide one-template batch.

Quick answer: separate the student case from the document register

Keep one reviewed student in StudentCase. List the certificate, student letter, guardian letter, and other approved outputs in DocumentRegister. Each register row names a different Word template and its exact bookmark contract. Generate only when the case is READY and the document row is APPROVED.

Use the right neighboring workflow

For many independent recipients using one standard certificate template, use batch certificates from Excel. This guide deliberately covers the multi-template student pack.

Create the one-row StudentCase contract

A — CaseID

Unique Windows-safe case identifier used in the run folder and filenames.

B — StudentID

Stable student identifier stored as text when leading zeros matter.

C — StudentName

Reviewed display name used across the approved documents.

D — ProgramName

Course, program, award, or enrollment context.

E — CompletionDateDisplay

Document-ready date text, not an Excel serial.

F — GuardianName

Optional case value; required only by templates that list its bookmark.

G — SchoolName

Approved school or issuing organization name.

H — SignatoryName

Printed name of the authorized signatory.

I — CaseStatus

Use exactly READY, HOLD, or DONE; only READY can run.

Use DocumentRegister to define each different output

A — DocumentKey

Unique business key such as CERTIFICATE or GUARDIAN_LETTER.

B — TemplateFile

A unique DOCX filename stored in Templates.

C — OutputSuffix

Unique safe suffix combined with CaseID for output filenames.

D — RequiredBookmarks

Exact semicolon-separated contract, including at least CaseID and StudentName.

E — SignatureFile

PNG/JPG/JPEG filename when SignatureImage is required; otherwise blank.

F — DocumentStatus

Use exactly APPROVED or RETIRED.

Example contracts

CaseID;StudentID;StudentName;ProgramName;CompletionDateDisplay;SchoolName;SignatoryName;SignatureImage
CaseID;StudentID;StudentName;GuardianName;SchoolName;SignatoryName

Make every Word template declare its own data needs

Exact bookmark names

Allowed names are CaseID, StudentID, StudentName, ProgramName, CompletionDateDisplay, GuardianName, SchoolName, SignatoryName, and SignatureImage.

Uniform text placeholders

Use one style inside each text bookmark. Do not hide fields, content controls, images, paragraph marks, or cell markers inside it.

Controlled signature bookmark

Use an otherwise empty SignatureImage bookmark only when the register also provides an approved signature filename.

Clean review state

Turn off Track Changes, resolve revisions in every Word story, and remove comments before approval.

Generate the pack through six controlled gates

1. Review one case

Confirm identity, program, display date, guardian data, school, signatory, and READY status.

2. Approve the register

Approve only the different document types required for this student case.

3. Freeze run inputs

Copy every approved template and unique signature into InputSnapshot.

4. Validate each contract

Open each template copy read-only and confirm its exact required bookmarks and review state.

5. Stage each pair

Create nonempty DOCX/PDF files, then move the pair into Completed without overwrite.

6. Review the complete pack

Check privacy, identity, wording, signatures, layout, filenames, PDF rendering, and case status before release.

Free Excel VBA example: build one guarded student pack

Save the workbook as .xlsm, create the two sheets exactly as specified, place templates in Templates and signatures in Assets\Signatures, then run GenerateStudentDocumentPack. The code snapshots inputs, rejects changed Excel data, validates each template contract, and keeps the run folder after failure.

Excel VBA — one student case, several Word templatesStatic example
Option Explicit

Private Const CASE_SHEET As String = "StudentCase"
Private Const REGISTER_SHEET As String = "DocumentRegister"
Private Const STATUS_READY As String = "READY"
Private Const STATUS_HOLD As String = "HOLD"
Private Const STATUS_DONE As String = "DONE"
Private Const DOC_APPROVED As String = "APPROVED"
Private Const DOC_RETIRED As String = "RETIRED"
Private Const WD_FORMAT_DOCX As Long = 12
Private Const WD_EXPORT_PDF As Long = 17
Private Const WD_ALERTS_NONE As Long = 0
Private Const WD_DO_NOT_SAVE_CHANGES As Long = 0
Private Const WD_COLLAPSE_START As Long = 1
Private Const OFFICE_TRUE As Long = -1
Private Const POINTS_PER_CM As Double = 28.3464567

Public Sub GenerateStudentDocumentPack()
    Dim wb As Workbook
    Dim caseWs As Worksheet
    Dim registerWs As Worksheet
    Dim fso As Object
    Dim wdApp As Object
    Dim doc As Object
    Dim caseData As Variant
    Dim registerData As Variant
    Dim templateSnapshots As Object
    Dim signatureSnapshots As Object
    Dim documentKeys As Object
    Dim templateFiles As Object
    Dim outputSuffixes As Object
    Dim requiredBookmarks As Object
    Dim caseId As String
    Dim studentId As String
    Dim studentName As String
    Dim programName As String
    Dim completionDateDisplay As String
    Dim guardianName As String
    Dim schoolName As String
    Dim signatoryName As String
    Dim caseStatus As String
    Dim documentKey As String
    Dim templateFile As String
    Dim outputSuffix As String
    Dim bookmarkContract As String
    Dim signatureFile As String
    Dim documentStatus As String
    Dim templateFolder As String
    Dim signatureFolder As String
    Dim outputRoot As String
    Dim runFolder As String
    Dim inputFolder As String
    Dim templateSnapshotFolder As String
    Dim signatureSnapshotFolder As String
    Dim stagingFolder As String
    Dim completedFolder As String
    Dim sourcePath As String
    Dim snapshotPath As String
    Dim tempDocxPath As String
    Dim tempPdfPath As String
    Dim finalDocxPath As String
    Dim finalPdfPath As String
    Dim outputStem As String
    Dim lastRegisterRow As Long
    Dim dataRow As Long
    Dim excelRow As Long
    Dim approvedCount As Long
    Dim generatedCount As Long
    Dim previousScreenUpdating As Boolean
    Dim previousEnableEvents As Boolean
    Dim stateCaptured As Boolean
    Dim currentStep As String
    Dim errorNumber As Long
    Dim errorDescription As String

    On Error GoTo CleanFail
    Set wb = ThisWorkbook
    previousScreenUpdating = Application.ScreenUpdating
    previousEnableEvents = Application.EnableEvents
    stateCaptured = True
    Application.ScreenUpdating = False
    Application.EnableEvents = False

    currentStep = "checking the macro-enabled workbook"
    RequireWritableMacroWorkbook wb
    Set caseWs = RequireWorksheet(wb, CASE_SHEET)
    Set registerWs = RequireWorksheet(wb, REGISTER_SHEET)
    If caseWs.ProtectContents Or registerWs.ProtectContents Then
        Err.Raise vbObjectError + 5100, , _
            "StudentCase and DocumentRegister must allow status updates."
    End If
    ValidateCaseHeaders caseWs
    ValidateRegisterHeaders registerWs
    RequireOneCaseRow caseWs

    caseData = caseWs.Range("A2:I2").Value2
    caseId = ReadRequiredText(caseData(1, 1), "CaseID", 2)
    studentId = ReadRequiredText(caseData(1, 2), "StudentID", 2)
    studentName = ReadRequiredText(caseData(1, 3), "StudentName", 2)
    programName = ReadRequiredText(caseData(1, 4), "ProgramName", 2)
    completionDateDisplay = ReadRequiredText( _
        caseData(1, 5), "CompletionDateDisplay", 2)
    guardianName = ReadOptionalText(caseData(1, 6), "GuardianName", 2)
    schoolName = ReadRequiredText(caseData(1, 7), "SchoolName", 2)
    signatoryName = ReadRequiredText(caseData(1, 8), "SignatoryName", 2)
    caseStatus = ReadRequiredText(caseData(1, 9), "CaseStatus", 2)
    ValidateCaseStatus caseStatus
    If caseStatus <> STATUS_READY Then
        Err.Raise vbObjectError + 5101, , _
            "StudentCase row 2 must be exactly READY for generation."
    End If
    ValidateFileComponent caseId, "CaseID", 2

    templateFolder = JoinPath(wb.Path, "Templates")
    signatureFolder = JoinPath(JoinPath(wb.Path, "Assets"), "Signatures")
    outputRoot = JoinPath(wb.Path, "GeneratedStudentPacks")
    RequireFolder templateFolder, "template folder"

    lastRegisterRow = FindLastDataRow(registerWs, 6)
    If lastRegisterRow < 2 Then
        Err.Raise vbObjectError + 5102, , _
            "DocumentRegister has no document rows."
    End If
    registerData = registerWs.Range("A2:F" & lastRegisterRow).Value2
    Set documentKeys = NewTextDictionary(vbTextCompare)
    Set templateFiles = NewTextDictionary(vbTextCompare)
    Set outputSuffixes = NewTextDictionary(vbTextCompare)

    currentStep = "preflighting the document register"
    For dataRow = 1 To UBound(registerData, 1)
        excelRow = dataRow + 1
        If Not DataRowIsBlank(registerData, dataRow, 6) Then
            documentStatus = ReadRequiredText( _
                registerData(dataRow, 6), "DocumentStatus", excelRow)
            ValidateDocumentStatus documentStatus, excelRow
            If documentStatus = DOC_APPROVED Then
                documentKey = ReadRequiredText( _
                    registerData(dataRow, 1), "DocumentKey", excelRow)
                templateFile = ReadRequiredText( _
                    registerData(dataRow, 2), "TemplateFile", excelRow)
                outputSuffix = ReadRequiredText( _
                    registerData(dataRow, 3), "OutputSuffix", excelRow)
                bookmarkContract = ReadRequiredText( _
                    registerData(dataRow, 4), "RequiredBookmarks", excelRow)
                signatureFile = ReadOptionalText( _
                    registerData(dataRow, 5), "SignatureFile", excelRow)

                ValidateKey documentKey, "DocumentKey", excelRow
                ValidateDocxFileName templateFile, excelRow
                ValidateFileComponent outputSuffix, "OutputSuffix", excelRow
                AddUnique documentKeys, documentKey, "DocumentKey", excelRow
                AddUnique templateFiles, templateFile, "TemplateFile", excelRow
                AddUnique outputSuffixes, outputSuffix, "OutputSuffix", excelRow
                Set requiredBookmarks = ParseBookmarkContract( _
                    bookmarkContract, excelRow)
                If requiredBookmarks.Exists("GuardianName") And _
                   Len(guardianName) = 0 Then
                    Err.Raise vbObjectError + 5159, , _
                        "GuardianName is required by the template contract " & _
                        "on DocumentRegister row " & excelRow & "."
                End If
                ValidateSignatureContract requiredBookmarks, signatureFile, excelRow

                sourcePath = JoinPath(templateFolder, templateFile)
                RequireNonemptyFile sourcePath, _
                    "template on DocumentRegister row " & excelRow
                If Len(signatureFile) > 0 Then
                    ValidateImageFileName signatureFile, excelRow
                    sourcePath = JoinPath(signatureFolder, signatureFile)
                    RequireNonemptyFile sourcePath, _
                        "signature on DocumentRegister row " & excelRow
                End If
                approvedCount = approvedCount + 1
            End If
        End If
    Next dataRow
    If approvedCount = 0 Then
        Err.Raise vbObjectError + 5103, , _
            "DocumentRegister has no rows marked exactly APPROVED."
    End If

    currentStep = "saving the preflighted workbook"
    wb.Save
    Set fso = CreateObject("Scripting.FileSystemObject")
    EnsureFolder outputRoot
    runFolder = CreateRunFolder(fso, outputRoot, caseId)
    inputFolder = JoinPath(runFolder, "InputSnapshot")
    templateSnapshotFolder = JoinPath(inputFolder, "Templates")
    signatureSnapshotFolder = JoinPath(inputFolder, "Signatures")
    stagingFolder = JoinPath(runFolder, "Staging")
    completedFolder = JoinPath(runFolder, "Completed")
    fso.CreateFolder inputFolder
    fso.CreateFolder templateSnapshotFolder
    fso.CreateFolder signatureSnapshotFolder
    fso.CreateFolder stagingFolder
    fso.CreateFolder completedFolder
    Set templateSnapshots = NewTextDictionary(vbTextCompare)
    Set signatureSnapshots = NewTextDictionary(vbTextCompare)

    currentStep = "creating the controlled input snapshot"
    For dataRow = 1 To UBound(registerData, 1)
        If CStr(registerData(dataRow, 6)) = DOC_APPROVED Then
            templateFile = CStr(registerData(dataRow, 2))
            sourcePath = JoinPath(templateFolder, templateFile)
            snapshotPath = JoinPath(templateSnapshotFolder, templateFile)
            CopyFileToSnapshot fso, sourcePath, snapshotPath, _
                "template " & templateFile
            templateSnapshots.Add templateFile, snapshotPath

            signatureFile = CStr(registerData(dataRow, 5))
            If Len(signatureFile) > 0 And _
               Not signatureSnapshots.Exists(signatureFile) Then
                sourcePath = JoinPath(signatureFolder, signatureFile)
                snapshotPath = JoinPath(signatureSnapshotFolder, signatureFile)
                CopyFileToSnapshot fso, sourcePath, snapshotPath, _
                    "signature " & signatureFile
                signatureSnapshots.Add signatureFile, snapshotPath
            End If
        End If
    Next dataRow

    currentStep = "starting Microsoft Word Desktop"
    Set wdApp = CreateObject("Word.Application")
    wdApp.Visible = False
    wdApp.DisplayAlerts = WD_ALERTS_NONE
    wdApp.ScreenUpdating = False

    For dataRow = 1 To UBound(registerData, 1)
        excelRow = dataRow + 1
        If CStr(registerData(dataRow, 6)) = DOC_APPROVED Then
            currentStep = "rechecking the student case and register row " & excelRow
            RequireRangeUnchanged caseWs.Range("A2:I2"), caseData, 1, 9, _
                "StudentCase row 2"
            RequireRangeUnchanged registerWs.Range("A" & excelRow & _
                ":F" & excelRow), registerData, dataRow, 6, _
                "DocumentRegister row " & excelRow

            documentKey = CStr(registerData(dataRow, 1))
            templateFile = CStr(registerData(dataRow, 2))
            outputSuffix = CStr(registerData(dataRow, 3))
            bookmarkContract = CStr(registerData(dataRow, 4))
            signatureFile = CStr(registerData(dataRow, 5))
            Set requiredBookmarks = ParseBookmarkContract( _
                bookmarkContract, excelRow)
            outputStem = caseId & "_" & outputSuffix
            ValidateFileComponent outputStem, "combined output name", excelRow
            tempDocxPath = JoinPath(stagingFolder, outputStem & ".docx")
            tempPdfPath = JoinPath(stagingFolder, outputStem & ".pdf")
            finalDocxPath = JoinPath(completedFolder, outputStem & ".docx")
            finalPdfPath = JoinPath(completedFolder, outputStem & ".pdf")
            RequireTargetAbsent tempDocxPath
            RequireTargetAbsent tempPdfPath
            RequireTargetAbsent finalDocxPath
            RequireTargetAbsent finalPdfPath

            currentStep = "generating " & documentKey
            Set doc = wdApp.Documents.Open( _
                templateSnapshots(templateFile), False, True, False)
            ValidateTemplate doc, requiredBookmarks, templateFile
            PopulateRequiredBookmarks doc, requiredBookmarks, _
                caseId, studentId, studentName, programName, _
                completionDateDisplay, guardianName, schoolName, _
                signatoryName, signatureFile, signatureSnapshots
            ValidateResultBeforeSave doc, requiredBookmarks, documentKey
            doc.SaveAs2 tempDocxPath, WD_FORMAT_DOCX
            doc.ExportAsFixedFormat tempPdfPath, WD_EXPORT_PDF, False, 0, _
                0, 1, 1, 0, True, True, 0, True, True, False
            doc.Close WD_DO_NOT_SAVE_CHANGES
            Set doc = Nothing

            RequireNonemptyFile tempDocxPath, "staged DOCX " & documentKey
            RequireNonemptyFile tempPdfPath, "staged PDF " & documentKey
            Name tempDocxPath As finalDocxPath
            Name tempPdfPath As finalPdfPath
            generatedCount = generatedCount + 1
        End If
    Next dataRow

    currentStep = "confirming the complete case and document register"
    If FindLastDataRow(caseWs, 9) <> 2 Then
        Err.Raise vbObjectError + 5160, , _
            "StudentCase row count changed after preflight."
    End If
    If FindLastDataRow(registerWs, 6) <> lastRegisterRow Then
        Err.Raise vbObjectError + 5161, , _
            "DocumentRegister row count changed after preflight."
    End If
    RequireTableUnchanged caseWs.Range("A2:I2"), caseData, 1, 9, _
        "StudentCase"
    RequireTableUnchanged registerWs.Range("A2:F" & lastRegisterRow), _
        registerData, UBound(registerData, 1), 6, "DocumentRegister"
    If generatedCount <> approvedCount Then
        Err.Raise vbObjectError + 5162, , _
            "Generated document count does not match the approved count."
    End If

    caseWs.Cells(2, 9).Value2 = STATUS_DONE
    wb.Save
    wdApp.NormalTemplate.Saved = True
    wdApp.Quit WD_DO_NOT_SAVE_CHANGES
    Set wdApp = Nothing
    RestoreExcelState previousScreenUpdating, previousEnableEvents
    stateCaptured = False
    MsgBox "Student document pack completed." & vbCrLf & _
        "Documents generated: " & generatedCount & vbCrLf & _
        "Completed folder: " & completedFolder & vbCrLf & vbCrLf & _
        "Review identity, privacy, signatures, DOCX, and PDF before release.", _
        vbInformation

CleanExit:
    On Error Resume Next
    If Not doc Is Nothing Then doc.Close WD_DO_NOT_SAVE_CHANGES
    If Not wdApp Is Nothing Then
        wdApp.NormalTemplate.Saved = True
        wdApp.Quit WD_DO_NOT_SAVE_CHANGES
    End If
    If stateCaptured Then _
        RestoreExcelState previousScreenUpdating, previousEnableEvents
    On Error GoTo 0
    Exit Sub

CleanFail:
    errorNumber = Err.Number
    errorDescription = Err.Description
    On Error Resume Next
    If Not doc Is Nothing Then doc.Close WD_DO_NOT_SAVE_CHANGES
    If Not wdApp Is Nothing Then
        wdApp.NormalTemplate.Saved = True
        wdApp.Quit WD_DO_NOT_SAVE_CHANGES
    End If
    If stateCaptured Then _
        RestoreExcelState previousScreenUpdating, previousEnableEvents
    On Error GoTo 0
    MsgBox "Student pack generation stopped while " & currentStep & "." & _
        vbCrLf & "Error " & errorNumber & ": " & errorDescription & _
        vbCrLf & IIf(Len(runFolder) > 0, _
            "Inspect the retained run folder: " & runFolder, _
            "No run folder was created.") & vbCrLf & _
        "Existing completed files were not deleted.", vbCritical
End Sub

Private Sub PopulateRequiredBookmarks(ByVal doc As Object, _
                                      ByVal required As Object, _
                                      ByVal caseId As String, _
                                      ByVal studentId As String, _
                                      ByVal studentName As String, _
                                      ByVal programName As String, _
                                      ByVal completionDate As String, _
                                      ByVal guardianName As String, _
                                      ByVal schoolName As String, _
                                      ByVal signatoryName As String, _
                                      ByVal signatureFile As String, _
                                      ByVal signatures As Object)
    Dim token As Variant
    For Each token In required.Keys
        Select Case CStr(token)
            Case "CaseID": WriteTextBookmark doc, CStr(token), caseId
            Case "StudentID": WriteTextBookmark doc, CStr(token), studentId
            Case "StudentName": WriteTextBookmark doc, CStr(token), studentName
            Case "ProgramName": WriteTextBookmark doc, CStr(token), programName
            Case "CompletionDateDisplay"
                WriteTextBookmark doc, CStr(token), completionDate
            Case "GuardianName": WriteTextBookmark doc, CStr(token), guardianName
            Case "SchoolName": WriteTextBookmark doc, CStr(token), schoolName
            Case "SignatoryName"
                WriteTextBookmark doc, CStr(token), signatoryName
            Case "SignatureImage"
                InsertSignatureBookmark doc, CStr(token), _
                    signatures(signatureFile)
        End Select
    Next token
End Sub

Private Sub ValidateTemplate(ByVal doc As Object, _
                             ByVal required As Object, _
                             ByVal templateFile As String)
    RejectTrackedChanges doc, "template " & templateFile
    If doc.Comments.Count > 0 Then
        Err.Raise vbObjectError + 5104, , _
            "Remove comments from template " & templateFile & "."
    End If
    ValidateBookmarkContract doc, required, templateFile
End Sub

Private Sub ValidateResultBeforeSave(ByVal doc As Object, _
                                     ByVal required As Object, _
                                     ByVal documentKey As String)
    RejectTrackedChanges doc, "generated document " & documentKey
    If doc.Comments.Count > 0 Then
        Err.Raise vbObjectError + 5105, , _
            "Generated document contains comments: " & documentKey
    End If
    ValidateBookmarkContract doc, required, documentKey
End Sub

Private Sub ValidateBookmarkContract(ByVal doc As Object, _
                                     ByVal required As Object, _
                                     ByVal documentLabel As String)
    Dim token As Variant
    Dim allowed As Object
    Set allowed = AllowedBookmarkNames()
    For Each token In required.Keys
        If Not doc.Bookmarks.Exists(CStr(token)) Then
            Err.Raise vbObjectError + 5106, , _
                "Missing bookmark " & token & " in " & documentLabel & "."
        End If
    Next token
    For Each token In allowed.Keys
        If doc.Bookmarks.Exists(CStr(token)) And _
           Not required.Exists(CStr(token)) Then
            Err.Raise vbObjectError + 5107, , _
                "Bookmark " & token & " exists but is not listed in " & _
                "RequiredBookmarks for " & documentLabel & "."
        End If
    Next token
End Sub

Private Function ParseBookmarkContract(ByVal contractText As String, _
                                       ByVal excelRow As Long) As Object
    Dim result As Object
    Dim allowed As Object
    Dim tokens As Variant
    Dim token As Variant
    Dim tokenText As String
    Set result = NewTextDictionary(vbBinaryCompare)
    Set allowed = AllowedBookmarkNames()
    tokens = Split(contractText, ";")
    For Each token In tokens
        tokenText = CStr(token)
        If Len(tokenText) = 0 Or tokenText <> Trim$(tokenText) Then
            Err.Raise vbObjectError + 5108, , _
                "RequiredBookmarks has an empty or padded token on row " & _
                excelRow & "."
        End If
        If Not allowed.Exists(tokenText) Then
            Err.Raise vbObjectError + 5109, , _
                "Unknown or incorrectly cased bookmark on row " & excelRow & _
                ": " & tokenText
        End If
        If result.Exists(tokenText) Then
            Err.Raise vbObjectError + 5110, , _
                "Duplicate bookmark token on row " & excelRow & ": " & tokenText
        End If
        result.Add tokenText, True
    Next token
    If Not result.Exists("CaseID") Or Not result.Exists("StudentName") Then
        Err.Raise vbObjectError + 5111, , _
            "Every approved template must require CaseID and StudentName."
    End If
    Set ParseBookmarkContract = result
End Function

Private Function AllowedBookmarkNames() As Object
    Dim result As Object
    Dim item As Variant
    Set result = NewTextDictionary(vbBinaryCompare)
    For Each item In Array("CaseID", "StudentID", "StudentName", _
        "ProgramName", "CompletionDateDisplay", "GuardianName", _
        "SchoolName", "SignatoryName", "SignatureImage")
        result.Add CStr(item), True
    Next item
    Set AllowedBookmarkNames = result
End Function

Private Sub ValidateSignatureContract(ByVal required As Object, _
                                      ByVal signatureFile As String, _
                                      ByVal excelRow As Long)
    If required.Exists("SignatureImage") And Len(signatureFile) = 0 Then
        Err.Raise vbObjectError + 5112, , _
            "SignatureFile is required when SignatureImage is listed on row " & _
            excelRow & "."
    End If
    If Not required.Exists("SignatureImage") And Len(signatureFile) > 0 Then
        Err.Raise vbObjectError + 5113, , _
            "SignatureFile must be blank when SignatureImage is not listed " & _
            "on row " & excelRow & "."
    End If
End Sub

Private Sub WriteTextBookmark(ByVal doc As Object, _
                              ByVal bookmarkName As String, _
                              ByVal replacementText As String)
    Dim targetRange As Object
    Dim styleValue As Variant
    Set targetRange = doc.Bookmarks(bookmarkName).Range
    If targetRange.Fields.Count > 0 Or _
       targetRange.ContentControls.Count > 0 Or _
       targetRange.InlineShapes.Count > 0 Then
        Err.Raise vbObjectError + 5114, , _
            "Text bookmark contains a nested object: " & bookmarkName
    End If
    RejectRangeMarkers targetRange, bookmarkName
    styleValue = targetRange.Style
    targetRange.Text = replacementText
    targetRange.Style = styleValue
    doc.Bookmarks.Add bookmarkName, targetRange
    If Not doc.Bookmarks.Exists(bookmarkName) Then
        Err.Raise vbObjectError + 5115, , _
            "Bookmark was not restored: " & bookmarkName
    End If
    If StrComp(doc.Bookmarks(bookmarkName).Range.Text, replacementText, _
       vbBinaryCompare) <> 0 Then
        Err.Raise vbObjectError + 5116, , _
            "Bookmark value differs after replacement: " & bookmarkName
    End If
End Sub

Private Sub InsertSignatureBookmark(ByVal doc As Object, _
                                    ByVal bookmarkName As String, _
                                    ByVal imagePath As String)
    Dim targetRange As Object
    Dim picture As Object
    Set targetRange = doc.Bookmarks(bookmarkName).Range
    If targetRange.Fields.Count > 0 Or _
       targetRange.ContentControls.Count > 0 Or _
       targetRange.InlineShapes.Count > 0 Then
        Err.Raise vbObjectError + 5117, , _
            "Signature bookmark contains a nested object."
    End If
    RejectRangeMarkers targetRange, bookmarkName
    targetRange.Text = ""
    targetRange.Collapse WD_COLLAPSE_START
    Set picture = doc.InlineShapes.AddPicture( _
        imagePath, False, True, targetRange)
    If picture.Width <= 0 Or picture.Height <= 0 Then
        Err.Raise vbObjectError + 5118, , _
            "Word inserted an invalid signature image."
    End If
    picture.LockAspectRatio = OFFICE_TRUE
    If picture.Width > 4.5 * POINTS_PER_CM Then _
        picture.Width = 4.5 * POINTS_PER_CM
    If picture.Height > 1.8 * POINTS_PER_CM Then _
        picture.Height = 1.8 * POINTS_PER_CM
    doc.Bookmarks.Add bookmarkName, picture.Range
    If doc.Bookmarks(bookmarkName).Range.InlineShapes.Count <> 1 Then
        Err.Raise vbObjectError + 5119, , _
            "Signature bookmark does not contain one embedded image."
    End If
End Sub

Private Sub RejectRangeMarkers(ByVal targetRange As Object, _
                               ByVal bookmarkName As String)
    If InStr(1, targetRange.Text, vbCr, vbBinaryCompare) > 0 Or _
       InStr(1, targetRange.Text, Chr$(7), vbBinaryCompare) > 0 Then
        Err.Raise vbObjectError + 5120, , _
            "Bookmark includes a paragraph or cell marker: " & bookmarkName
    End If
End Sub

Private Sub RejectTrackedChanges(ByVal doc As Object, _
                                 ByVal documentLabel As String)
    If doc.TrackRevisions Then
        Err.Raise vbObjectError + 5121, , _
            "Turn off Track Changes in " & documentLabel & "."
    End If
    If CountRevisionsInAllStories(doc) > 0 Then
        Err.Raise vbObjectError + 5122, , _
            "Resolve tracked revisions in every story of " & _
            documentLabel & "."
    End If
End Sub

Private Function CountRevisionsInAllStories(ByVal doc As Object) As Long
    Dim root As Object
    Dim story As Object
    Dim total As Long
    For Each root In doc.StoryRanges
        Set story = root
        Do While Not story Is Nothing
            total = total + story.Revisions.Count
            Set story = story.NextStoryRange
        Loop
    Next root
    CountRevisionsInAllStories = total
End Function

Private Sub ValidateCaseHeaders(ByVal ws As Worksheet)
    ValidateHeaders ws, Array("CaseID", "StudentID", "StudentName", _
        "ProgramName", "CompletionDateDisplay", "GuardianName", _
        "SchoolName", "SignatoryName", "CaseStatus")
End Sub

Private Sub ValidateRegisterHeaders(ByVal ws As Worksheet)
    ValidateHeaders ws, Array("DocumentKey", "TemplateFile", _
        "OutputSuffix", "RequiredBookmarks", "SignatureFile", _
        "DocumentStatus")
End Sub

Private Sub ValidateHeaders(ByVal ws As Worksheet, ByVal expected As Variant)
    Dim columnIndex As Long
    Dim valueText As Variant
    For columnIndex = 1 To UBound(expected) + 1
        valueText = ws.Cells(1, columnIndex).Value2
        If IsError(valueText) Or VarType(valueText) <> vbString Then
            Err.Raise vbObjectError + 5123, , _
                "Header " & ws.Cells(1, columnIndex).Address(False, False) & _
                " on " & ws.Name & " must contain exact text."
        End If
        If StrComp(CStr(valueText), CStr(expected(columnIndex - 1)), _
           vbBinaryCompare) <> 0 Then
            Err.Raise vbObjectError + 5124, , _
                "Expected header " & expected(columnIndex - 1) & _
                " in column " & columnIndex & " on " & ws.Name & "."
        End If
    Next columnIndex
End Sub

Private Sub RequireOneCaseRow(ByVal ws As Worksheet)
    Dim lastRow As Long
    lastRow = FindLastDataRow(ws, 9)
    If lastRow < 2 Then
        Err.Raise vbObjectError + 5125, , _
            "StudentCase row 2 is missing."
    End If
    If lastRow > 2 Then
        Err.Raise vbObjectError + 5126, , _
            "Contractor logic accepts one reviewed StudentCase row per run."
    End If
End Sub

Private Function FindLastDataRow(ByVal ws As Worksheet, _
                                 ByVal lastColumn As Long) As Long
    Dim lastCell As Range
    Set lastCell = ws.Range(ws.Cells(1, 1), _
        ws.Cells(ws.Rows.Count, lastColumn)).Find( _
        What:="*", After:=ws.Cells(1, 1), LookIn:=xlFormulas, _
        LookAt:=xlPart, SearchOrder:=xlByRows, _
        SearchDirection:=xlPrevious, MatchCase:=False)
    If lastCell Is Nothing Then
        FindLastDataRow = 0
    Else
        FindLastDataRow = lastCell.Row
    End If
End Function

Private Function DataRowIsBlank(ByRef data As Variant, _
                                ByVal dataRow As Long, _
                                ByVal columnCount As Long) As Boolean
    Dim columnIndex As Long
    DataRowIsBlank = True
    For columnIndex = 1 To columnCount
        If IsError(data(dataRow, columnIndex)) Or _
           Len(CStr(data(dataRow, columnIndex))) > 0 Then
            DataRowIsBlank = False
            Exit Function
        End If
    Next columnIndex
End Function

Private Function ReadRequiredText(ByVal rawValue As Variant, _
                                  ByVal fieldName As String, _
                                  ByVal excelRow As Long) As String
    ReadRequiredText = ReadOptionalText(rawValue, fieldName, excelRow)
    If Len(ReadRequiredText) = 0 Then
        Err.Raise vbObjectError + 5127, , _
            fieldName & " is required on row " & excelRow & "."
    End If
End Function

Private Function ReadOptionalText(ByVal rawValue As Variant, _
                                  ByVal fieldName As String, _
                                  ByVal excelRow As Long) As String
    If IsEmpty(rawValue) Then
        ReadOptionalText = ""
        Exit Function
    End If
    If IsError(rawValue) Or VarType(rawValue) <> vbString Then
        Err.Raise vbObjectError + 5128, , _
            fieldName & " must be stored as text on row " & excelRow & "."
    End If
    ReadOptionalText = CStr(rawValue)
    If ReadOptionalText <> Trim$(ReadOptionalText) Then
        Err.Raise vbObjectError + 5129, , _
            fieldName & " has outer whitespace on row " & excelRow & "."
    End If
    If ContainsControlCharacter(ReadOptionalText) Then
        Err.Raise vbObjectError + 5130, , _
            fieldName & " contains a control character on row " & excelRow & "."
    End If
End Function

Private Sub ValidateCaseStatus(ByVal statusText As String)
    If statusText <> STATUS_READY And statusText <> STATUS_HOLD And _
       statusText <> STATUS_DONE Then
        Err.Raise vbObjectError + 5131, , _
            "CaseStatus must be exactly READY, HOLD, or DONE."
    End If
End Sub

Private Sub ValidateDocumentStatus(ByVal statusText As String, _
                                   ByVal excelRow As Long)
    If statusText <> DOC_APPROVED And statusText <> DOC_RETIRED Then
        Err.Raise vbObjectError + 5132, , _
            "DocumentStatus must be exactly APPROVED or RETIRED on row " & _
            excelRow & "."
    End If
End Sub

Private Sub ValidateKey(ByVal valueText As String, _
                        ByVal fieldName As String, _
                        ByVal excelRow As Long)
    If Len(valueText) > 80 Then
        Err.Raise vbObjectError + 5133, , _
            fieldName & " exceeds 80 characters on row " & excelRow & "."
    End If
End Sub

Private Sub ValidateFileComponent(ByVal valueText As String, _
                                  ByVal fieldName As String, _
                                  ByVal excelRow As Long)
    Dim item As Variant
    Dim baseName As String
    Dim lowerName As String
    If Len(valueText) > 100 Then
        Err.Raise vbObjectError + 5134, , _
            fieldName & " exceeds 100 characters on row " & excelRow & "."
    End If
    For Each item In Array("<", ">", ":", Chr$(34), "/", "\", _
        "|", "?", "*")
        If InStr(1, valueText, CStr(item), vbBinaryCompare) > 0 Then
            Err.Raise vbObjectError + 5135, , _
                fieldName & " contains a forbidden Windows character on row " & _
                excelRow & "."
        End If
    Next item
    If Right$(valueText, 1) = "." Or Right$(valueText, 1) = " " Then
        Err.Raise vbObjectError + 5136, , _
            fieldName & " ends with a period or space on row " & excelRow & "."
    End If
    lowerName = LCase$(valueText)
    If Right$(lowerName, 5) = ".docx" Or _
       Right$(lowerName, 4) = ".pdf" Then
        Err.Raise vbObjectError + 5137, , _
            fieldName & " must not include .docx or .pdf on row " & excelRow & "."
    End If
    baseName = valueText
    If InStr(1, baseName, ".", vbBinaryCompare) > 0 Then
        baseName = Left$(baseName, InStr(1, baseName, ".", _
            vbBinaryCompare) - 1)
    End If
    If IsReservedWindowsName(baseName) Then
        Err.Raise vbObjectError + 5138, , _
            fieldName & " uses a reserved Windows name on row " & excelRow & "."
    End If
End Sub

Private Sub ValidateDocxFileName(ByVal fileName As String, _
                                 ByVal excelRow As Long)
    ValidateAssetFileName fileName, excelRow
    If LCase$(Right$(fileName, 5)) <> ".docx" Then
        Err.Raise vbObjectError + 5139, , _
            "TemplateFile must end with .docx on row " & excelRow & "."
    End If
End Sub

Private Sub ValidateImageFileName(ByVal fileName As String, _
                                  ByVal excelRow As Long)
    Dim lowerName As String
    ValidateAssetFileName fileName, excelRow
    lowerName = LCase$(fileName)
    If Right$(lowerName, 4) <> ".png" And _
       Right$(lowerName, 4) <> ".jpg" And _
       Right$(lowerName, 5) <> ".jpeg" Then
        Err.Raise vbObjectError + 5140, , _
            "SignatureFile must be PNG, JPG, or JPEG on row " & excelRow & "."
    End If
End Sub

Private Sub ValidateAssetFileName(ByVal fileName As String, _
                                  ByVal excelRow As Long)
    Dim item As Variant
    For Each item In Array("<", ">", ":", Chr$(34), "/", "\", _
        "|", "?", "*")
        If InStr(1, fileName, CStr(item), vbBinaryCompare) > 0 Then
            Err.Raise vbObjectError + 5141, , _
                "Asset filename contains a path or wildcard on row " & _
                excelRow & "."
        End If
    Next item
    If Right$(fileName, 1) = "." Or Right$(fileName, 1) = " " Then
        Err.Raise vbObjectError + 5142, , _
            "Asset filename ends with a period or space on row " & excelRow & "."
    End If
End Sub

Private Sub AddUnique(ByVal values As Object, ByVal valueText As String, _
                      ByVal fieldName As String, ByVal excelRow As Long)
    If values.Exists(valueText) Then
        Err.Raise vbObjectError + 5143, , _
            "Duplicate " & fieldName & " on rows " & values(valueText) & _
            " and " & excelRow & ": " & valueText
    End If
    values.Add valueText, excelRow
End Sub

Private Function NewTextDictionary(ByVal compareMode As Long) As Object
    Dim result As Object
    Set result = CreateObject("Scripting.Dictionary")
    result.CompareMode = compareMode
    Set NewTextDictionary = result
End Function

Private Sub RequireRangeUnchanged(ByVal liveRange As Range, _
                                  ByRef snapshot As Variant, _
                                  ByVal snapshotRow As Long, _
                                  ByVal columnCount As Long, _
                                  ByVal rangeLabel As String)
    Dim liveData As Variant
    Dim columnIndex As Long
    liveData = liveRange.Value2
    For columnIndex = 1 To columnCount
        If Not ValuesExactlyEqual(snapshot(snapshotRow, columnIndex), _
           liveData(1, columnIndex)) Then
            Err.Raise vbObjectError + 5144, , _
                rangeLabel & " changed after preflight. Start a new run."
        End If
    Next columnIndex
End Sub

Private Sub RequireTableUnchanged(ByVal liveRange As Range, _
                                  ByRef snapshot As Variant, _
                                  ByVal expectedRows As Long, _
                                  ByVal expectedColumns As Long, _
                                  ByVal tableLabel As String)
    Dim liveData As Variant
    Dim rowIndex As Long
    Dim columnIndex As Long

    If liveRange.Rows.Count <> expectedRows Or _
       liveRange.Columns.Count <> expectedColumns Then
        Err.Raise vbObjectError + 5163, , _
            tableLabel & " dimensions changed after preflight."
    End If
    liveData = liveRange.Value2
    For rowIndex = 1 To expectedRows
        For columnIndex = 1 To expectedColumns
            If Not ValuesExactlyEqual(snapshot(rowIndex, columnIndex), _
               liveData(rowIndex, columnIndex)) Then
                Err.Raise vbObjectError + 5164, , _
                    tableLabel & " changed after preflight at row " & _
                    (rowIndex + 1) & ", column " & columnIndex & "."
            End If
        Next columnIndex
    Next rowIndex
End Sub

Private Function ValuesExactlyEqual(ByVal firstValue As Variant, _
                                    ByVal secondValue As Variant) As Boolean
    If IsError(firstValue) Or IsError(secondValue) Then Exit Function
    If VarType(firstValue) <> VarType(secondValue) Then Exit Function
    ValuesExactlyEqual = (StrComp(CStr(firstValue), CStr(secondValue), _
        vbBinaryCompare) = 0)
End Function

Private Sub CopyFileToSnapshot(ByVal fso As Object, _
                               ByVal sourcePath As String, _
                               ByVal snapshotPath As String, _
                               ByVal fileLabel As String)
    Dim sourceSize As Variant
    Dim sourceModified As Date
    Dim failureText As String
    RequireNonemptyFile sourcePath, fileLabel
    RequireTargetAbsent snapshotPath
    On Error GoTo CopyFailed
    sourceSize = fso.GetFile(sourcePath).Size
    sourceModified = fso.GetFile(sourcePath).DateLastModified
    fso.CopyFile sourcePath, snapshotPath, False
    RequireNonemptyFile snapshotPath, fileLabel & " snapshot"
    If fso.GetFile(snapshotPath).Size <> sourceSize Then
        Err.Raise vbObjectError + 5145, , _
            "Snapshot size differs for " & fileLabel & "."
    End If
    If fso.GetFile(sourcePath).Size <> sourceSize Or _
       fso.GetFile(sourcePath).DateLastModified <> sourceModified Then
        Err.Raise vbObjectError + 5146, , _
            "Source changed while snapshotting " & fileLabel & "."
    End If
    Exit Sub
CopyFailed:
    failureText = Err.Description
    Err.Raise vbObjectError + 5147, , _
        "Could not snapshot " & fileLabel & ": " & failureText
End Sub

Private Function CreateRunFolder(ByVal fso As Object, _
                                 ByVal outputRoot As String, _
                                 ByVal caseId As String) As String
    Dim baseName As String
    Dim candidate As String
    Dim suffix As Long
    baseName = "Run_" & caseId & "_" & Format$(Now, "yyyymmdd_hhnnss")
    candidate = JoinPath(outputRoot, baseName)
    Do While fso.FolderExists(candidate)
        suffix = suffix + 1
        candidate = JoinPath(outputRoot, baseName & "_" & _
            Format$(suffix, "000"))
    Loop
    fso.CreateFolder candidate
    CreateRunFolder = candidate
End Function

Private Sub RequireWritableMacroWorkbook(ByVal wb As Workbook)
    If Len(wb.Path) = 0 Or LCase$(Right$(wb.Name, 5)) <> ".xlsm" Then
        Err.Raise vbObjectError + 5148, , _
            "Save this workbook as an Excel Macro-Enabled Workbook (.xlsm)."
    End If
    If wb.ReadOnly Then
        Err.Raise vbObjectError + 5149, , _
            "The workbook is read-only; DONE cannot be saved."
    End If
End Sub

Private Function RequireWorksheet(ByVal wb As Workbook, _
                                  ByVal sheetName As String) As Worksheet
    On Error GoTo MissingSheet
    Set RequireWorksheet = wb.Worksheets(sheetName)
    Exit Function
MissingSheet:
    Err.Raise vbObjectError + 5150, , _
        "Missing worksheet: " & sheetName
End Function

Private Sub EnsureFolder(ByVal folderPath As String)
    If FolderExistsStrict(folderPath) Then Exit Sub
    On Error GoTo CreateFailed
    MkDir folderPath
    Exit Sub
CreateFailed:
    Err.Raise vbObjectError + 5151, , _
        "Could not create folder: " & folderPath & ". " & Err.Description
End Sub

Private Sub RequireFolder(ByVal folderPath As String, _
                          ByVal folderLabel As String)
    If Not FolderExistsStrict(folderPath) Then
        Err.Raise vbObjectError + 5152, , _
            "Missing " & folderLabel & ": " & folderPath
    End If
End Sub

Private Sub RequireTargetAbsent(ByVal filePath As String)
    If FileExistsStrict(filePath) Then
        Err.Raise vbObjectError + 5153, , _
            "Refusing to overwrite existing file: " & filePath
    End If
End Sub

Private Sub RequireNonemptyFile(ByVal filePath As String, _
                                ByVal fileLabel As String)
    If Not FileExistsStrict(filePath) Then
        Err.Raise vbObjectError + 5154, , _
            "Missing " & fileLabel & ": " & filePath
    End If
    On Error GoTo InspectFailed
    If FileLen(filePath) <= 0 Then
        Err.Raise vbObjectError + 5155, , _
            "Empty " & fileLabel & ": " & filePath
    End If
    Exit Sub
InspectFailed:
    Err.Raise vbObjectError + 5156, , _
        "Could not inspect " & fileLabel & ": " & filePath & _
        ". " & Err.Description
End Sub

Private Function FileExistsStrict(ByVal filePath As String) As Boolean
    On Error GoTo CheckFailed
    FileExistsStrict = (Len(Dir$(filePath, _
        vbNormal Or vbHidden Or vbSystem Or vbReadOnly)) > 0)
    Exit Function
CheckFailed:
    Err.Raise vbObjectError + 5157, , _
        "Could not check file path: " & filePath & ". " & Err.Description
End Function

Private Function FolderExistsStrict(ByVal folderPath As String) As Boolean
    Dim resultText As String
    On Error GoTo CheckFailed
    resultText = Dir$(folderPath, vbDirectory)
    If Len(resultText) > 0 Then
        FolderExistsStrict = _
            ((GetAttr(folderPath) And vbDirectory) = vbDirectory)
    End If
    Exit Function
CheckFailed:
    Err.Raise vbObjectError + 5158, , _
        "Could not check folder: " & folderPath & ". " & Err.Description
End Function

Private Function JoinPath(ByVal parentPath As String, _
                          ByVal childName As String) As String
    If Right$(parentPath, 1) = "\" Then
        JoinPath = parentPath & childName
    Else
        JoinPath = parentPath & "\" & childName
    End If
End Function

Private Function ContainsControlCharacter(ByVal valueText As String) As Boolean
    Dim index As Long
    Dim code As Long
    For index = 1 To Len(valueText)
        code = AscW(Mid$(valueText, index, 1))
        If code >= 0 And code <= 31 Then
            ContainsControlCharacter = True
            Exit Function
        End If
    Next index
End Function

Private Function IsReservedWindowsName(ByVal baseName As String) As Boolean
    Dim upperName As String
    Dim suffixText As String
    Dim suffixCode As Long
    upperName = UCase$(baseName)
    Select Case upperName
        Case "CON", "PRN", "AUX", "NUL", "CLOCK$"
            IsReservedWindowsName = True
            Exit Function
    End Select
    If Len(upperName) >= 4 Then
        If Left$(upperName, 3) = "COM" Or Left$(upperName, 3) = "LPT" Then
            suffixText = Mid$(upperName, 4)
            If Len(suffixText) = 1 Then
                suffixCode = AscW(suffixText)
                If (suffixCode >= AscW("1") And suffixCode <= AscW("9")) Or _
                   suffixText = ChrW$(&HB9) Or suffixText = ChrW$(&HB2) Or _
                   suffixText = ChrW$(&HB3) Then
                    IsReservedWindowsName = True
                End If
            End If
        End If
    End If
End Function

Private Sub RestoreExcelState(ByVal screenUpdatingValue As Boolean, _
                              ByVal enableEventsValue As Boolean)
    Application.EnableEvents = enableEventsValue
    Application.ScreenUpdating = screenUpdatingValue
End Sub

The example uses Microsoft Word’s documented bookmark checks, embedded images, DOCX save, and PDF export.

Review student documents as one coordinated release

Identity and scope

Match CaseID, StudentID, student name, program, guardian, and the approved document list.

Visual output

Inspect long names, spacing, dates, school branding, signatures, pagination, DOCX, and PDF.

Privacy and access

Keep student data, generated files, and signature assets in access-controlled local folders.

Authorization

An embedded signature image is not a digital signature or proof that its owner approved this release.

Know what the example does not guarantee

No atomic pack commit

Pairs move separately and DONE is saved later; reconcile a retained partial run.

No legal or policy approval

The macro cannot decide whether a document may be issued or shared.

No automatic distribution

Review and deliver through an approved channel after generation.

No roster batching

The macro intentionally accepts one StudentCase row per run.

No cryptographic signature

A raster signature image does not authenticate a signer.

No mixed-format replacement

Keep every text bookmark uniformly styled.

Use Contractor for the multi-template student case

DocxForge Pro Contractor matches this workflow: one reviewed case reuses shared data across several different documents created from different Word templates.

Where Contractor fits

Use it when the same student data must feed a certificate, student letter, guardian letter, or other distinct templates. Factory is the different workflow for many independent rows and one standard template.

DocxForge Pro Contractor workflow for school certificates and student letters
Review shared student case data.
DocxForge Pro Contractor workflow for school certificates and student letters
Confirm the case structure and reusable fields.
DocxForge Pro Contractor workflow for school certificates and student letters
Select the different approved Word templates.
DocxForge Pro Contractor workflow for school certificates and student letters
Review naming and output settings before generation.
Build coordinated student document packs with Contractor7 days free, then $38 every 3 months • 14-day refund after purchase.
One reviewed caseSeveral templatesDOCX + PDFLocal processing
Start Free 7-Day Trial

Frequently asked questions

Is this a whole-school certificate batch?

No. This workflow processes one reviewed student case and creates several different documents from different templates. For many independent rows using one certificate template, use the batch certificates guide.

Which documents can belong to the student pack?

Typical approved rows include a certificate, student letter, guardian letter, or completion notice. Every document has its own template, output suffix, bookmark contract, optional signature, and approval status.

Can GuardianName be blank?

Yes, unless an approved template lists GuardianName in its required bookmark contract. The case data and template register must agree before generation.

Does an image prove that a school official signed the document?

No. A signature image is not a digital signature or proof of authorization. Restrict access to assets and approve their use separately before releasing student documents.

Can a failed run leave a partial document pack?

Yes. Each DOCX/PDF pair is staged and moved separately, while the case becomes DONE only after the complete pack is generated and the workbook saves. Reconcile the retained run folder before retrying.

Where does DocxForge Pro Contractor fit?

Contractor matches this scenario: one reviewed case reuses shared data across several different documents created from different Word templates. Factory is the separate pattern for many independent rows and one standard template.

Turn one reviewed student case into a controlled document packUse several approved Word templates locally. 7 days free, then $38 every 3 months • 14-day refund.
Contractor workflowShared case dataDifferent templatesLocal Word Desktop
Start Free 7-Day Trial