If you want the emails sent at a specific date and time, enter that date and time into the “Scheduled Date” column using the format: “dd/mm/yyyy hh:hh,” and copy-paste it into every column you want.Ĩ. To send the attachment to all recipients, move your mouse to the bottom right corner of the cell with the attachment until your cursor turns into a black cross, then click-and-drag it all the way down your contacts list.ħ. Once the attachment is added, you can copy-paste it to other recipients in the sheet. Next, go to “Add-ons -> Mail Merge with Attachments -> Add File Attachments,” then select the location from which you’d like to add your attachments.Ħ. To do this, select the column under “File Attachments” that corresponds to the contact you’d like to send the attachment to.ĥ. Once you’ve imported your contacts, you can add attachments to send to specific (or all) contacts in the mail merge. (If you haven’t yet created the group you want to send a Mail Merge to, you should do so in Google Contacts first.)Ĥ. To import your Google Contacts, go to “Add-ons -> Mail Merge with Attachments -> Import Google Contacts,” then select which of your Contacts groups you want to add people from. Next, you could add contacts manually, but if you want to save yourself some work and have all the contacts you need in Google Contacts, you can just import them over instead. Various categories should appear that will help you manage the list of contacts you’ll be sending your mail merge to.ģ. Next, open a blank Google Sheets document, then select “Add-ons -> Mail Merge with Attachments -> Create Merge Template.” (You’ll need to sign into your Google account.)Ģ. Add this mail merge attachment to your Gmail account. The Premium version ($29) ups this to 250 for standard Gmail accounts and 1500 if you have a Google Apps for Work account.ġ. Note: the free version of this extension limits you to 50 emails per day, though you can schedule it to send emails over sequential days.
#MAIL MERGE GOOGLE HOW TO#
In this article we’ll show you how to send a mail merge in Gmail using the “Mail Merge with Attachments” add-on for Google Sheets.
0 kommentar(er)
