This guide shows you how to mail merge with attachments in Mailmeteor.
Mailmeteor lets you mail merge with attachments in Gmail. It's possible to attach files, like pictures or PDF to each of your emails sent easily.
Adding attachments is a Premium feature.
To mail merge with attachments, create a new template and click on the attachment icon as shown below:
Add attachments to your emails
You can then drag and drop one or multiple files as well as browsing your local files by clicking on the "Choose files" button. The files are shortly uploaded right after.
With this method, you will attach the same files to all emails sent with this template. This means that all of your recipients will receive the same files. If you want to send individual files to each recipient, see the section below.
Sending a mail merge with personalized attachments is a powerful solution that lets you for example send invoices to your customers or payslips to your employees.
To automate this recurrent task, here's what you need to do:
- 1.Upload your file to a Google Drive folder
- 2.Select the file and right-click on it
- 3.Click Share or ShareGet link.
- 4.Under “Get Link,” click Change to anyone with link
- 5.Copy the link and paste it into your spreadsheet under a column where you will put all personalized attachments. The column should be named "Attachment" or "Attachments"
- 6.Repeat the steps for each of your recipient
Once your spreadsheet is filled, open Mailmeteor, select your template or create a new one, then click "Send emails". Mailmeteor will pull out each file and attach it to the relevant email - exactly as for personalized variables.
If you are not familiar with Google Drive, look at this in-depth tutorial on how to send a mail merge with personalized attachments (with screenshots).
Mailmeteor recommends that you upload your files on Google Drive - for ease of use. But you can use other tools, such as Dropbox or Amazon S3, as well as your own servers.
To make sure Mailmeteor can attach your personalized attachments, just make sure your file is publicly accessible on the web.
- You can add up to 5 attachments per email (including both personalized as well as non-personalized attachments).
- To send multiple attachments, create multiple columns named "Attachment1", "Attachment2", etc. Each column should start with "Attachment".
- The total size of your attachments should not exceed 5MB in size.
It the same spreadsheet used by this in-depth tutorial about sending individual attachments in Gmail. In the spreadsheet, you will notice it contains a column named "Attachment". If you send a new campaign with Mailmeteor, each of your recipient will receive the file linked in this column "Attachment".
Either you add personalized attachments or non-personalized ones to your emails, Mailmeteor allows only small files (up to 5MB) to ensure the overall deliverability of your campaign. Indeed, sending a high volume of emails containing large files is not recommended in terms of email deliverability.
To attach larger files in your email, we recommend to add a Google Drive link in your template. Here's how to do it:
- 1.Upload your file to your Google Drive
- 2.Select file and right-click on it
- 3.Click Share or ShareGet link.
- 4.Under “Get Link,” click Change to anyone with link (or restrict to specific emails)
- 5.Copy the link that Google Drive will give you
- 6.Now open a template in Mailmeteor (or create a new template)
- 7.Paste the link in your template
This will add a link into your emails that your recipients can click on to download the file. You can even create an anchor, such as "Click here to download the file".
In Gmail, Google Drive links also appear as an attachment in your recipient"s inbox. So it's totally transparent for your recipient.
There might be different reasons why attachments are failing. We list the issues in our dedicated support page:
- File is too large (max is 5MB per file as well as in total)
- Too many attachments (max is 5 files per email)
- Blocked for security issue
- Spam issues
If your usage relies heavily on attachments, we generally recommend hosting files online (e.g. on Google Drive) and only sharing the link to the files in your emails. That's a best practice, recommended by industry leaders such as Mailchimp as well.
If you prefer watching a video, here's a tutorial on attaching files to your mail merge in Mailmeteor: