How to Create Offline Proposal Packs from Excel, Word, and PDF
Build proposal packs without uploading client data to a cloud document service. Prepare controlled text in Excel, keep layout in approved Word templates, generate editable DOCX files, export final PDFs locally, and choose the right workflow for one reviewed case or a larger batch.
Quick answer: define the pack before automating it
An offline proposal pack is a controlled set of client-specific files created on the Windows PC from approved source data and templates. The pack should have a clear owner, output structure, review step, and final delivery format.
Source of truth
Excel holds the approved client, commercial, date, and output-name values used for generation.
Layout owner
Word templates control styles, headers, tables, page breaks, signature areas, and legal text.
Editable output
DOCX remains available when staff must make a reviewed, case-specific adjustment before delivery.
Final output
PDF provides the fixed-layout version that is easier to distribute, archive, and compare with the approved draft.
Use one folder per ProposalID. Store the editable DOCX, final PDF, and any approved supporting files together. Do not use the client name alone as the identifier because names can repeat or change.
Choose the workflow by the unit of work
The word “pack” can describe two different jobs. Decide which one you have before configuring templates or writing code.
Use Contractor when one opportunity needs reviewed data and several different outputs, such as a cover letter, proposal, pricing appendix, and terms document from different Word templates. Case data can also be loaded from Excel before review.
Use Factory when every Excel row should produce a separate proposal from the same Word template, with naming rules, photo-folder handling, batch-size control, and optional PDF output.
If one row should become one finished file, the one-row-to-one-document guide covers the underlying model in more detail.
Prepare the Excel source as a data contract
Each column should have one stable meaning. Avoid merged cells, decorative header rows, and formulas whose displayed result is ambiguous outside Excel.
ProposalID
Use a unique, non-empty identifier for folders, filenames, audit notes, and reruns.
Client and contact
Keep organization, contact name, title, address, and email in separate columns.
Commercial values
Separate numeric calculation columns from final display columns such as DealValueDisplay and TaxDisplay.
Dates and validity
Keep real Excel dates for sorting, then create approved text columns such as ValidUntilDisplay for the document.
Scope and options
Use clear fields for package name, scope summary, payment terms, and approved optional sections.
Images and attachments
Store controlled logo, signature, or product-image paths in dedicated columns and validate that each required file exists.
A raw number such as 12500 does not define currency, separators, decimals, or tax treatment. Prepare the exact approved string in Excel and pass that text into Word. This avoids depending on the operator's regional settings or a narrow Excel column that displays ####.
Build the Word template for variable-length content
The generator fills data; the template still owns layout. Test the template with the longest realistic client name, scope paragraph, price table, and image before approving it.
Use styles instead of manual formatting
Define headings, body text, captions, and table text through Word styles so changes remain consistent.
Keep placeholders in one formatting run
Do not split one tag across differently formatted characters. For DocxForge, use clear tags such as {{ClientName}} and documented photo tags.
Control tables and page breaks
Set column widths, row behavior, paragraph spacing, and keep-with-next rules in the template instead of repairing every output.
Separate approved templates
Give each template a version and owner. Do not let a production run silently use an unapproved draft from a shared folder.
Use the reusable Word template guide for the full template checklist. If generated output shifts, compare the source and result with the Word formatting troubleshooting guide.
Free VBA fallback: one proposal folder per Excel row
This Excel VBA example is a limited fallback for a simple batch: one Word template, four required bookmarks, and one DOCX plus one PDF per row. It does not assemble several different templates into one reviewed case workflow.
Save the Excel file as an Excel Macro-Enabled Workbook (.xlsm). Create a sheet named Proposals, put the headers in row 1, and use columns A–D for ProposalID, ClientName, DealValueDisplay, and StartDateDisplay. Store ProposalID, DealValueDisplay, and StartDateDisplay as document-ready text. Format the ID column as Text before entering or importing IDs when leading zeros must be preserved. Put ProposalTemplate.docx in a Templates folder beside the workbook.
Create the Word bookmarks ProposalID, ClientName, DealValue, and StartDate. This example writes plain text and reapplies the bookmark range's Word style after replacement. It does not promise preservation of mixed direct formatting and is not a universal method for repeating tables, images, headers, or conditional sections.
Option Explicit
Private Const wdFormatXMLDocument As Long = 12
Private Const wdExportFormatPDF As Long = 17
Private Const wdExportOptimizeForPrint As Long = 0
Private Const wdDoNotSaveChanges As Long = 0
Private Const wdAlertsNone As Long = 0
Public Sub CreateOfflineProposalPacks()
Const SHEET_NAME As String = "Proposals"
Const TEMPLATE_SUBFOLDER As String = "Templates"
Const TEMPLATE_FILE As String = "ProposalTemplate.docx"
Const OUTPUT_SUBFOLDER As String = "ProposalPacks"
Dim ws As Worksheet
Dim wdApp As Object
Dim wdDoc As Object
Dim templatePath As String
Dim outputRoot As String
Dim packFolder As String
Dim basePath As String
Dim docxPath As String
Dim pdfPath As String
Dim proposalId As String
Dim clientName As String
Dim dealValueText As String
Dim startDateText As String
Dim fileStem As String
Dim lastRow As Long
Dim rowNumber As Long
Dim savedCount As Long
Dim currentStep As String
Dim previousScreenUpdating As Boolean
On Error GoTo CleanFail
previousScreenUpdating = Application.ScreenUpdating
Application.ScreenUpdating = False
currentStep = "checking the workbook"
If Len(ThisWorkbook.Path) = 0 Then
Err.Raise vbObjectError + 1600, , _
"Save this Excel workbook before running the macro."
End If
Set ws = ThisWorkbook.Worksheets(SHEET_NAME)
templatePath = ThisWorkbook.Path & "\" & TEMPLATE_SUBFOLDER & _
"\" & TEMPLATE_FILE
outputRoot = ThisWorkbook.Path & "\" & OUTPUT_SUBFOLDER
If Dir(templatePath, vbNormal) = "" Then
Err.Raise vbObjectError + 1601, , _
"Word template not found: " & templatePath
End If
EnsureFolder outputRoot
currentStep = "starting Microsoft Word"
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = False
wdApp.DisplayAlerts = wdAlertsNone
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
If lastRow < 2 Then
Err.Raise vbObjectError + 1602, , _
"No proposal rows were found on the Proposals sheet."
End If
For rowNumber = 2 To lastRow
currentStep = "validating Excel row " & rowNumber
proposalId = Trim$(CStr(ws.Cells(rowNumber, "A").Value2))
clientName = Trim$(CStr(ws.Cells(rowNumber, "B").Value2))
dealValueText = Trim$(CStr(ws.Cells(rowNumber, "C").Value2))
startDateText = Trim$(CStr(ws.Cells(rowNumber, "D").Value2))
If Len(proposalId) = 0 Then
Err.Raise vbObjectError + 1603, , _
"ProposalID is blank on Excel row " & rowNumber & "."
End If
If Len(clientName) = 0 Then
Err.Raise vbObjectError + 1604, , _
"ClientName is blank on Excel row " & rowNumber & "."
End If
fileStem = SafeWindowsName(proposalId & "_" & clientName)
If Len(fileStem) = 0 Then
Err.Raise vbObjectError + 1605, , _
"The output name is invalid on Excel row " & rowNumber & "."
End If
packFolder = outputRoot & "\" & fileStem
EnsureFolder packFolder
basePath = packFolder & "\Proposal_" & fileStem
docxPath = basePath & ".docx"
pdfPath = basePath & ".pdf"
If Dir(docxPath, vbNormal) <> "" Or Dir(pdfPath, vbNormal) <> "" Then
Err.Raise vbObjectError + 1606, , _
"Output already exists for Excel row " & rowNumber & ": " & basePath
End If
currentStep = "opening the Word template for Excel row " & rowNumber
Set wdDoc = wdApp.Documents.Open(templatePath, False, True, False)
WriteRequiredBookmark wdDoc, "ProposalID", proposalId, False
WriteRequiredBookmark wdDoc, "ClientName", clientName, False
WriteRequiredBookmark wdDoc, "DealValue", dealValueText, False
WriteRequiredBookmark wdDoc, "StartDate", startDateText, False
currentStep = "saving DOCX for Excel row " & rowNumber
wdDoc.SaveAs2 docxPath, wdFormatXMLDocument, False, "", False
currentStep = "exporting PDF for Excel row " & rowNumber
wdDoc.ExportAsFixedFormat pdfPath, wdExportFormatPDF, False, _
wdExportOptimizeForPrint
wdDoc.Close wdDoNotSaveChanges
Set wdDoc = Nothing
savedCount = savedCount + 1
Next rowNumber
MsgBox savedCount & " proposal pack(s) created in:" & vbCrLf & _
outputRoot, vbInformation
CleanExit:
On Error Resume Next
If Not wdDoc Is Nothing Then wdDoc.Close wdDoNotSaveChanges
If Not wdApp Is Nothing Then wdApp.Quit
Set wdDoc = Nothing
Set wdApp = Nothing
Application.ScreenUpdating = previousScreenUpdating
Exit Sub
CleanFail:
MsgBox "Stopped while " & currentStep & ":" & vbCrLf & _
Err.Description, vbExclamation
Resume CleanExit
End Sub
Private Sub WriteRequiredBookmark(ByVal doc As Object, _
ByVal bookmarkName As String, _
ByVal replacementText As String, _
Optional ByVal allowBlank As Boolean = False)
Dim targetRange As Object
Dim originalStyle As Variant
If Not allowBlank And Len(Trim$(replacementText)) = 0 Then
Err.Raise vbObjectError + 1609, , _
"Required value is blank for Word bookmark: " & bookmarkName
End If
If Not doc.Bookmarks.Exists(bookmarkName) Then
Err.Raise vbObjectError + 1610, , _
"Required Word bookmark is missing: " & bookmarkName
End If
Set targetRange = doc.Bookmarks(bookmarkName).Range
originalStyle = targetRange.Style
targetRange.Text = replacementText
targetRange.Style = originalStyle
doc.Bookmarks.Add bookmarkName, targetRange
If Not doc.Bookmarks.Exists(bookmarkName) Then
Err.Raise vbObjectError + 1611, , _
"Word bookmark was not restored: " & bookmarkName
End If
End Sub
Private Sub EnsureFolder(ByVal folderPath As String)
Dim fileSystem As Object
Set fileSystem = CreateObject("Scripting.FileSystemObject")
If Not fileSystem.FolderExists(folderPath) Then
fileSystem.CreateFolder folderPath
End If
End Sub
Private Function SafeWindowsName(ByVal rawValue As String) As String
Dim result As String
Dim invalidChar As Variant
Dim controlCode As Long
Dim dotPosition As Long
Dim stem As String
result = Trim$(rawValue)
For Each invalidChar In Array("\", "/", ":", "*", "?", Chr$(34), "<", ">", "|")
result = Replace(result, CStr(invalidChar), "_")
Next invalidChar
For controlCode = 0 To 31
result = Replace(result, Chr$(controlCode), "")
Next controlCode
If Len(result) > 90 Then result = Left$(result, 90)
Do While Len(result) > 0
If Right$(result, 1) <> "." And Right$(result, 1) <> " " Then Exit Do
result = Left$(result, Len(result) - 1)
Loop
If Len(result) = 0 Then Exit Function
stem = UCase$(result)
dotPosition = InStr(1, stem, ".", vbBinaryCompare)
If dotPosition > 0 Then stem = Left$(stem, dotPosition - 1)
Select Case stem
Case "CON", "PRN", "AUX", "NUL", _
"COM1", "COM2", "COM3", "COM4", "COM5", _
"COM6", "COM7", "COM8", "COM9", _
"LPT1", "LPT2", "LPT3", "LPT4", "LPT5", _
"LPT6", "LPT7", "LPT8", "LPT9"
result = "_" & result
End Select
SafeWindowsName = result
End FunctionThe macro suppresses ordinary Word alerts in its hidden Word instance, rejects blank required values, validates bookmarks, reapplies each bookmark range's Word style, cleans Windows filenames, refuses to overwrite an existing DOCX or PDF, and closes Word during error cleanup. Alert suppression reduces the risk of a hidden prompt but does not guarantee that every external or security dialog can be bypassed. If PDF export fails after the DOCX was saved, inspect and remove or archive that partial pack before rerunning.
The example uses Word's documented SaveAs2 method, ExportAsFixedFormat method, and Bookmarks.Exists check. Static review does not replace a test in Word Desktop with a disposable workbook and template.
Review the pack at three levels
Do not open every file and improvise a review. Define what is checked in the data, the editable document, and the final PDF.
Excel row
Confirm ProposalID, client identity, approved commercial values, dates, scope, and required paths.
Folder and filenames
Confirm one folder per ID, expected extensions, no duplicate outputs, and no temporary Word files.
DOCX content
Check placeholder replacement, styles, page breaks, tables, images, headers, footers, and editable text.
PDF content
Compare page count, pagination, fonts, hyperlinks, image quality, and signature areas with the reviewed DOCX.
Exception record
Test long text, a blank optional field, the largest image, an accented name, and an existing filename collision.
Review evidence
Record the template version, source file, generation date, operator, and approval status outside the final client-facing document.
See both DocxForge Pro workflows before testing
DocxForge Pro is a local Windows suite that keeps Word templates in control. Contractor and Factory solve different proposal-production jobs, so test the module that matches the unit of work.
Load or enter one case, review its values, and choose the different Word templates required for that proposal pack.
Load the Excel table, use one Word template, configure naming and output options, and generate separate files for the selected rows.
Contractor: reviewed case data and document selection
Factory: Excel data and batch generation
Offline generation still needs operational controls
Keeping the files on the PC changes where data is processed. It does not automatically provide access control, encryption, recovery, or approval evidence.
Restrict source folders
Grant access only to staff who need the client data, templates, and generated packs.
Protect approved templates
Separate production templates from drafts and record who approves a new version.
Back up source and output
Include the workbook, templates, generated files, and review records in a tested recovery process.
Set a retention rule
Define when proposals, supporting images, exports, and superseded drafts should be archived or deleted.
Generated files can still be copied, emailed, synchronized by another application, or exposed through an unsecured Windows account. Treat offline processing as one architecture choice inside a wider security process.
Implement the workflow with a six-record pilot
Use difficult records before committing the team to a new template, macro, or application.
1. Freeze the template version
Copy the approved Word template into a test folder and record its version.
2. Prepare six rows
Include normal, long, blank-optional, accented, missing-file, and duplicate-output cases.
3. Generate DOCX first
Check mapped values, layout, images, tables, and editable text before relying on PDF export.
4. Compare PDF output
Confirm page count, fonts, links, images, and signature areas against the reviewed DOCX.
5. Test failure and rerun
Correct one rejected record and confirm existing approved output is not silently overwritten.
6. Measure operator work
Record preparation, review, correction, and rerun time. Compare the result with the workaround-cost method.
Frequently asked questions
Short answers about creating proposal packs locally from Excel and Word.
What should an offline proposal pack contain?
Use one folder per unique ProposalID. Include the reviewed editable DOCX, the final PDF, and only the approved supporting documents needed for delivery. Keep internal review notes and source data outside the client-facing files.
Should one Excel row create one proposal or several documents?
Use one row and one template when each record needs the same proposal structure. Use a reviewed case workflow when one opportunity needs several different documents from different Word templates.
How should currency and dates move from Excel to Word?
Keep numeric and date cells for calculation and sorting, then create separate approved display-text columns for the final document. Pass those strings to Word so currency, separators, decimals, and date wording remain intentional.
Can the VBA example create images or conditional sections?
No. The example deliberately covers four plain-text bookmarks and one template. Images, repeating data, headers, mixed-format placeholders, and conditional sections require additional tested logic or a configured document-generation workflow.
What is the difference between Contractor and Factory for proposals?
Contractor is for one reviewed opportunity that may produce several different documents from different templates. Factory is for many Excel rows that each produce a separate document from one Word template.
Does offline generation make proposal data secure?
It reduces the need to upload source files to a cloud document service, but security still depends on Windows accounts, folder permissions, encryption, backups, retention rules, and how staff distribute the finished files.