Mail Merge with Attachments in Excel & Outlook
Send personalized emails with multiple attachments, dynamic tables, CC/BCC support and fail-safe validation — directly from Excel.
Get Leksi →Why Mail Merge with Attachments in Outlook is difficult
- Cannot attach different files per recipient
- Manual attachment selection required
- High risk of sending wrong files
- Complex VBA scripts required
- No built-in attachment validation
Manual Workarounds People Try
- Writing VBA Macros, Requires coding knowledge. Difficult to maintain. Breaks easily when Excel structure changes
- Gmail Plugins: Often attach the same file to all recipients or rely on cloud storage links
- Manual Sending: Time-consuming and extremely risky for HR, payroll, finance, or compliance communication.
Leksi Max: A Smarter Way to Do Mail Merge with Attachments
- Attach up to 30 files per recipient
- Dynamic CC and BCC columns
- Insert personalized table data (variable rows)
- HTML email formatting support
- Sequential fail-safe sending process
How It Works
- Install Leksi Max add-in
- Click on Mailmerge With Attachments on Leksi Max Tab
- Fill recepients table, To, CC, BCC, Subject, Custom Columns, Attachments with full path (Upto 30 per mail)
- One row in recepient table is one mail
- Draft email in HTML format with placeholders for customization
- Map column names and placeholders in mapping table
- optionally fill link table and link info column if table data to be sent
- Click on "Send Mails Now" to send mails row by row
Real Enterprise Use Case
HR teams sending 500 appraisal letters:
- Auto-attach employee-specific PDFs
- Insert appraisal table dynamically
- CC respective HRBP
- Stop immediately if attachment missing
Manual VBA vs Structured Automation
| Capability | Manual VBA | Leksi Max |
|---|---|---|
| Multiple Attachments | Custom Coding Required | Up to 30 Per Email |
| Dynamic Tables | Complex Script | Built-In |
| Error Control | Unpredictable | Fail-Safe Sequential |