📧 Liberty Foundation Email System
Send personalized skill training proposal letters with Exact PDF Template
Ref #, College Name & Date auto-fill | Everything else same as template
📤 Upload College Data (Excel File)
Format Required: Column A - College Name | Column B - Email | Column C - Reference Number | Column D - Date (DD/MM/YYYY)
Example: ABC College | abc@college.com | LF/SKILL/2026/001 | 2024-01-15
✍️ Send Single Email (Manual Entry)
Send email without adding to database
📋 Manage Colleges
📧 Send All Pending Emails
Send personalized PDFs with Ref #, College Name & Date to all pending colleges.
Rate Limited: 1 email per second to avoid spam filters (Brevo: 300/day)
🎨 Letter Template Design
Upload a PNG/JPG image of your letter design (export your Canva/PDF design as an image),
then click on the preview to place where College Name, Ref No
and Date should appear. Every generated PDF will use this exact design with
those three fields filled in dynamically.
PDF upload also works if the server has Imagick installed — otherwise export as PNG/JPG first.