Excel Email Sender — Bulk Individual Emails with Attachments via Gmail (No Coding Needed)
What is this tool?Excel Email Sender is a ready-to-use Microsoft Excel macro tool that lets you send personalised emails — each with a different PDF attachment — to a list of people, all from your own Gmail account. No programming skills needed.Who is it for?· Schools & Colleges — Send progress reports, fee receipts, or hall tickets to parents· Hospitals & Clinics — Share individual patient reports or appointment letters· Insurance Companies — Dispatch policy documents or renewal notices individually· Banks & Financial Firms — Send account statements or loan documents· HR Departments — Distribute salary slips or offer letters to employees· Any organisation that sends bulk emails where each person gets a different attachmentKey Features· One-click sending — fill in your details and click 'Send All Emails'· Individual attachments — each person receives their own PDF file automatically· Personalised subject & body — use {Name} and {EnrollNo} placeholders, auto-replaced per row· Live status tracking — each row shows Sent (green) or Failed (red) in Column E· Preview mode — check how the email looks for the first person before sending to all· Clear status button — reset all statuses and resend anytime· Works with Gmail using a secure App Password — no less-secure app settings required· Three easy sheets: INSTRUCTIONS, SETTINGS, and EMAIL LIST· Includes a step-by-step PDF setup guideWhat you get in this download· Create_Email_Sender.vbs — setup script that builds the Excel file on your PC automatically· Email_Sender.xlsm — the ready-to-use Excel macro workbook (created by the script)· Gmail_Setup_Guide.pdf — full step-by-step guide covering Gmail IMAP, App Password, Developer Tab, and VBA ReferencesHow to use it — 4 simple steps1. Read the PDF guide and set up Gmail (IMAP + App Password) — takes 5 minutes2. Run Create_Email_Sender.vbs — Excel file appears on your Desktop automatically3. Fill in SETTINGS (your Gmail, App Password, subject, body, attachment folder)4. Add your list in EMAIL LIST and click 'Send All Emails'Requirements· Windows PC with Microsoft Excel (2016 or later)· Gmail account with IMAP enabled· Gmail App Password (free, generated from your Google Account — guide included)PDF files saved in a folder on your computer (one per person, named by their ID)
Get it → swamystudio.gumroad.com