You can make a copy for your own use.Ī similar product that has been pre-built is Yet Another Mail Merge. Here is an example Mail Merge Spreadsheet available to members of the Brown community. The tutorial is slightly outdated, so it might help to have some foundational knowledge of Google Apps Script. Using this tutorial, you can create a Google spreadsheet that sends a mail merge. Ask your department's IT support staff to help you set this up. You can continue to send mail merges using Outlook, but you must configure Outlook to connect to your GoogleApps account. Connecting Outlook to Your Google Apps Account Otherwise, recipients might Reply All and send email to the rest of the group.

If you are using a Google Group to send announcements, we recommend requesting that it is set up so that only you (Manager) can post to the group. Google Groups are requested through the IT Service Center. If you need to email the same group of people periodically, this may be a good option. When you send mail to that address, it is delivered directly to all members of the group. Google Groups: Every Google Group has an email address. This is a good solution if it's a one-time mailing or if the recipient list changes every time you send an email. If you don't need to customize content for your recipients, you can simply BCC them on an email or use a Google Group.īCC: You can put your own (or your department's) address in the To field and paste the list of recipients into Bcc.

For more detailed information, see Google's Support Page on Sending Limits. In addition to these limitations, Google will temporarily disable your account if you exceed these limits or if you send a large number of undeliverable messages.Īccording to the Google help center, you can only send a message to up to 100 people at a time if you use POP or IMAP. 10,000 total recipients per day (for example, you could send 20 emails, each with 500 recipients).500 unique recipients per message (external) or 2,000 (internal).2,000 messages per day (i.e., you can hit 'Send' a maximum of 2,000 times).Here are the limits, from Google's help pages: It's important to be aware of these limits when doing a mail merge. In order to prevent spam, Google will temporarily disable accounts which send a lot of email in a short time.

How to do a mail merge in outlook