Raiffeisen-Landesbank Steiermark AG, headquartered in Graz, forms the largest banking group in southern Austria together with 56 Styrian Raiffeisen banks.
Challenge
Payroll staff had to manually create letters about bonuses, functional allowances, and special payments — an error-prone and time-intensive process, especially when dealing with hundreds of recipients at once.
Solution
Document generation was fully automated using Microsoft VBA macros. Staff can now generate hundreds of personalized letters with a single click, as both PDF and Word documents, based on employee data stored in Excel.
The application selects pre-built templates based on control parameters, populates employee-specific information, and preserves the original formatting for future adjustments by staff.
The automation saves time and costs while eliminating manual processing errors.
Results
- Hundreds of personalized letters at the click of a button
- PDF and Word export from a single interface
- Manual processing errors eliminated
Screenshots
Services Provided
- Requirements Analysis
- Concept & Consulting
- Process Digitalization
- Automation
- VBA Macro Development
