I need to send an email blast to 10,000 email contacts. This check is in place to prevent you from accidentally sending multiple emails to the same address should you run merge multiple times.ġ6. You’ve either run out of email quota or because the Mail Merge Status column in the spreadsheet is set to “MAIL SENT”. I am running Mail Merge but it is simply not sending the emails. The messages will be scheduled and they will be automatically delivered when your quota is reset.ġ5. You can add a schedule date that is 3-4 from now and run mail merge. I have run out of my daily email quota? How do I send emails automatically when the quota is reset by Google?
No, the Google Add-on runs in the background on Google Servers and you can close the Google Sheet after configuration.ġ4. Do I have to keep my computer open for the scheduled emails to go at specific time? The emails are scheduled in the timezone of the Google Spreadsheet.ġ3. So if you have scheduled an email to go out at 2:15 PM, it can go anytime between 2-2:30 PM. The scheduled emails are sent +/- 30 minutes of the scheduled time. I am scheduling an email but it is sending it right away. You can also use mailto for link to email addresses.ġ2. On the Configure Mail Merge screen, click the “Send a Test Email” button and it will send a sample email to the developer with the and they’ll be substituted with the actual hyperlink. It is always a good idea to test your email campaign before sending a blast to multiple people. Go to the Mail Merge menu again and choose “Configure Mail Merge” – the status column will change to “MAIL SENT” for all email messages that were successfully delivered.Mail Merge will automatically insert the actual file into the email. If you would like to add file attachment to your email messages – say a PDF file or a Word document – just upload the file to Google Drive and then select Insert File Attachments to insert that link of the file into the Mail merge sheet.Alternatively, you can compose an email template in rich text using the HTML Mail tool and then copy-paste the generated HTML code into the message body field of the Google Sheet. Go to Gmail and create a new draft email messages that will become the template for Mail merge.It will now automatically import all the associated Gmail contacts into the spreadsheet. Under the Mail Merge menu, choose Import Google Contacts and select the Google Contacts group that you created in Step 3.Alternatively, you can enter the names and email addresses of recipients directly in the Mail Merge Google Sheet. Open Google Contacts and create a new Group with all the contacts who you would like to send a personalized email.
Go to the Add-ons menu in the sheet, select Mail Merge with Attachments and then select the Create Merge Template menu.