Template Filler
A GUI program that fills in merge fields in a Microsoft Word document using data in a Microsoft Excel spreadsheet.
Usage
- Create an Excel spreadsheet to be linked to the Word document.
- Open Word
- Click the Mailings tab
- “Select Recipients”
- “Use an Existing List…”
- Find and open the Excel spreadsheet
- Insert merge fields in the Word document.
- Place the cursor where a merge field should be inserted
- Click the Mailings tab
- “Insert Merge Field”
- The fields that appear are the header labels from the Excel spreadsheet.
- Capitalize any merge fields, if needed
- Right click a merge field
- “Edit Field…”
- Under “Format”, click “First capital”
Features
Automatically omits the s in instances of ‘s if preceded by a name that ends in s.
Dependencies
Written in Python 3.9.
Enter pip install requirements.txt
in the console to automatically download dependencies.
- python-docx
- pandas
- openpyxl
- PyQt5