Payroll payslip email system
Mail settings → upload Excel (headers on row 3, data from row 4) → subject/body templates → validation & preview → send per employee. Upload contents and SMTP passwords stay in browser sessionStorage and request memory only; nothing is persisted in Prisma/DB.
Mail settings
Enter your own SMTP account, save, then send a test email to verify connectivity.
Each visitor sends mail through their own SMTP credentials—not the MS Ventures site mail (Resend).
SMTP credentials are stored only in this browser’s sessionStorage—not on the server or in MS Ventures env vars.
Step 1. Upload Excel
Only `.xlsx` files can be uploaded. Download sample file
- Workbooks protected with an open password cannot be uploaded. In Excel, use File → Info → Protect Workbook → Encrypt with Password to remove protection, save, then upload again.
- If the workbook has multiple sheets, choose the payroll sheet and click "Load selected sheet". A single-sheet file loads automatically.
- Payroll rows are read with column headers on row 3 and employee data from row 4.
Step 2. Email subject & body
Available placeholders: {{employeeName}}, {{employeeId}}, {{department}}, {{designation}}, {{month}}, {{payrollMonth}}, {{payslip}} (payslip HTML table — if omitted, it is appended at the end of the body)
{{payrollMonth}}: pay period label — use a Payroll Month (or Pay Month) column on the MSV sheet when needed; on the legacy sheet it matches the Month column. {{month}} on MSV is Working Month (months since hire). {{payslip}} inserts the payslip HTML; if omitted, it is still appended when sending.
Upload Excel and pick an employee below to preview the rendered subject and body.