MergelineMail merge for job seekers: personal applications from Gmail
Updated October 29, 2026
Keep a sheet with one row per company: the contact, the role, the job link and one line on why you fit. Write one short email that uses those columns, send it from your own Gmail at a slow pace, and follow up once after about a week. Each hiring manager gets an email written for them.
Why mail merge helps a job search
A job search is a numbers game played one person at a time. You might write to 50 companies in a month, and each email has to feel like it was written only for that company. Copying, pasting and swapping names by hand is where the mistakes happen: the wrong company name in the second paragraph, the wrong job title, a forgotten attachment.
People ask how to do this exact thing: send “many personalized job applications” at once (r/excel: cold email many personalized job applications). Mail merge keeps the personal parts in a sheet, so the email stays consistent and the details stay right.
Set up your job tracker sheet
| Column | Example | Why |
|---|---|---|
| jane.doe@example.com | The hiring manager or recruiter, not jobs@ | |
| FirstName | Jane | For the greeting |
| Company | Acme | For the subject and body |
| Role | Product designer | So nobody gets the wrong title |
| Reason | I used Acme’s booking app for two years | The line that makes it personal |
| JobLink | The posting URL | Shows you read it |
The Reason column is the important one. Fill it by hand for every row. It takes a minute per company and does more than any template trick.
How to send job applications with Mergeline
- Build the tracker. One row per company with Email, FirstName, Company, Role, Reason and JobLink.
- Import it. Paste the Google Sheets link or drop the CSV into a new Mergeline campaign.
- Write the email. Use {{Role}} and {{Company}} in the subject and {{Reason}} in the first line.
- Read every preview. Make sure each Reason reads well in the sentence.
- Send 10 to 20 a day. Set a low daily cap and weekday sending hours.
- Track replies. Mergeline marks who replied, so your tracker stays current.
Write an email a hiring manager will read
Keep it under 120 words. Hiring managers skim on their phones.
Subject: {{Role}} at {{Company}}
“Hi {{FirstName|there}}, {{Reason}}, so the {{Role}} opening caught my eye. I have four years of experience in this field and recently led a project like the one in your posting. Would you be open to a short call next week? My resume is here: [link]. Thanks, Sam Lee”
Notice the order: them first, you second, one small ask last.
Resume: attach it or link it?
A link to your resume (a shared PDF in Google Drive, for example) keeps the email small and works on any plan. An attachment feels more traditional and some recruiters prefer it.
In Mergeline, attachments are a Pro feature and go with the first email only, so follow-ups stay light. Read mail merge with attachments for details.
Pace and limits
A job search rarely needs volume. Ten to twenty careful emails a day is plenty, and well under Gmail’s limit of 500 a day on a free account (Google: Gmail sending limits). Mergeline’s free plan sends up to 60 emails a day, which covers almost any search.
Send on weekday mornings in the company’s time zone, and never send the same company two emails on the same day from different rows.
Follow up once, then let it go
A single follow-up about a week later is normal and often gets the reply. More than two starts to look desperate. Follow-ups that stop on reply are part of Mergeline Pro, so nobody who already answered gets a nudge. Pro is $12 a month or $99 a year, and you can cancel when you land the job.
Cold emailing recruiters
Recruiters get many emails. Make yours easy to act on: the role you want, where you are based, one line of proof, and a link to your profile. Ask whether they hire for that role, not for a job outright. For more on safe outreach, read how to send cold email from Gmail safely.
Mistakes to avoid
- Sending to generic addresses like jobs@ when you could find the hiring manager.
- Leaving the Reason column empty and letting a fallback cover it.
- Attaching a large resume file to every email and every follow-up.
- Emailing several people at the same small company on the same day.
- Following up three or four times. Once is polite, twice is the limit.
Questions
Should I use AI to write the personal line?
It can help you draft, and Mergeline Pro can write a first line with your own AI key. Read and edit every line, since a wrong detail costs more than no detail.
Is it OK to mass email job applications?
Sending many applications is fine. Sending one generic email is not. Mail merge lets each email carry a real reason you picked that company.
How many applications can I send a day from Gmail?
Gmail allows 500 a day on a free account. For a job search, 10 to 20 thoughtful emails a day works better. Mergeline Free covers 60.
Will recruiters know it was a mail merge?
Not from the email itself. Each one is sent separately from your Gmail. They can only tell if the writing is generic.
Can I attach my resume?
Yes, with Mergeline Pro, or link to it from a shared file on any plan.
When should I follow up?
About a week after the first email, once, in the same thread.
Sources
- r/excel: cold email many personalized job applications
- Google: Gmail sending limits
- r/coldemail: cold emailing with $0
Facts checked October 29, 2026. Google and other vendors change their limits and prices, so check the source before you rely on a number.
Mergeline does this from your own Gmail. Free for 60 emails a day with merge tags and no branding. Pro is $12 a month or $99 a year for follow-ups, scheduling and attachments.