Back to Projects
Relance Client
2025- Context
For a company's sales-administration team.
- Problem
Generating an overdue/unpaid invoice statement client by client and preparing the email was long, repetitive, and error-prone.
- Solution
An automation that filters the client's data, highlights overdue invoices, computes key totals with auditable formulas, generates the final file, and prepares the reminder email in Outlook. Strict per-client data isolation.
- Result
Turns a tedious manual task into an instant, reliable process.
- Role
Data & AI Project Manager / end-to-end development.
- Tech stack
- Power Automate Desktop
- Excel
- Outlook
- PowerShell