How to Do Mail Merge with Gmail
Mail merge lets you send personalized emails to many recipients at once by inserting custom fields like names, companies, and offers. OutSends makes Gmail mail merge simple and powerful.
What you'll need
Before you start, make sure you have the following ready.
- An OutSends account
- A Gmail account connected to OutSends
- A CSV file with recipient data (names, emails, etc.)
Step-by-step guide
Follow these steps to complete the setup.
Prepare your data
Create a CSV file with headers like firstName, lastName, email, company, and any custom fields you want to use.
Import contacts
Upload your CSV to OutSends. Map each column to the corresponding merge field.
Write your email template
Create your email and insert merge tags like {{firstName}} where you want personalized content.
Preview personalization
Use the preview tool to see how your email looks with different recipients' data filled in.
Send or schedule
Choose to send immediately or schedule for later. OutSends will personalize each email automatically.
Tips for best results
Pro tips to get the most out of this setup.
- Test with a small sample first to verify merge fields work correctly
- Don't forget the fallback value for missing fields: {{firstName:there}}
- Double-check CSV column headers — they must match your merge tags exactly
Frequently asked questions
Can I use mail merge with attachments?
Yes, you can attach files to your mail merge. Each recipient gets the same attachment unless you use dynamic content blocks.
Is there a limit on how many recipients I can mail merge?
Your Gmail account's daily sending limit applies. OutSends lets you rotate across multiple Gmail accounts to scale up.
Can I use HTML templates in mail merge?
Yes, OutSends supports rich HTML templates with merge fields.
Related guides
Explore more how-to guides for OutSends.
Ready to get started?
Create a workspace, connect a sender, and launch your first campaign — free, no credit card.