01 — The friction
The calls weren’t the bottleneck. The paperwork was.
A team of 8–16 agents handled escalated calls from guests of a nationwide network of more than 400 franchise and corporate-owned motel properties. Every case they filed required them to stop and customize follow-up communications by hand in Word.
The document work competed directly with the calls waiting in queue. As agents edited names, case details, and language one file at a time, service levels fell—and rushed manual customization introduced grammar problems and other mistakes into customer-facing communication.
As the team began to grow, the problem compounded. Every new agent inherited the same manual process, multiplying the time spent on document handling, the training burden, and the opportunities for inconsistency.
“Why are we doing this repetitive thing manually?”
02 — The redesign
The solution wasn’t new software. It was using the old software differently.
The redesign was deliberately simple: refine the Word templates already in use, then load their content into the back end of an Excel workbook. A combination of VLOOKUP, data-validation lists, mail merge, and some creative misuse of Excel’s intended scope turned the spreadsheet into a controlled source document housing multiple templates that could easily generate several quality-assured letter types in moments.
Clean up and standardize the existing templates instead of starting over.
Store the template content behind an Excel interface and use VLOOKUP to retrieve the right language.
Use data-validation lists to force valid selections, produce specific outcomes, and prevent agent error.
Generate the appropriate, quality-assured letter type for each case in moments.
Office 365 was still in its infancy, and collaborative spreadsheets were fairly new to the game. I hosted a shared copy of the workbook on SharePoint, where Senior Agents could run letter batches throughout the day for printing or email. Frontline agents entered the case information, then returned to the phones instead of staying tied up producing documents.
03 — The result
The improvement kept frontline agents available for escalated calls while Senior Agents handled follow-up communications in efficient batches. It helped protect service levels, standardized the output, and reduced opportunities for avoidable errors.
Recognition The department head was so jazzed about the project that he wanted to watch the first time we “pushed the button” and generated a full batch of letters. He later recognized the project with an award.
04 — What it reveals
Nobody asked for a new system. The old one just wasn’t working.
The team needed more time for guests, not better Word-editing skills. Excel could handle the predictable parts; the agents could focus on the calls that required their judgment. The best part of the project wasn’t teaching Excel a new trick. It was giving people back the time to do the work they were actually there to do.