We want to create a newsletter for our department.

Brenau already subscribes to a tool called "YAMM" (Yet Another Mail Merge) which allows you to maintain a list of users in a spreadsheet and send them periodic communications.  Some departments have been procuring licenses for MailChimp but that will both take a lot of time to learn and it will cost the university about $200/yr.  We recommend you review the information below regarding YAMM.  If you decide you use MailChimp, you will need to contact the IT department before you send your first newsletter or it will fail.  There are changes that need to be made to the account in order for your MailChimp account to be authorized to send mail on Brenau's behalf.   Just let us know which way to decide to proceed.

Brenau has purchased a script for performing Mail Merges directly in Google Drive called "Yet Another Mail Merge". For information on how to use it, see the following video:

Watch

For detailed documentation, click here: https://support.yet-another-mail-merge.com/hc/en-us/categories/201313669-Getting-Started

This screenshot shows you were you will see the script when you are in a Google Spreadsheet:
http://www.screencast.com/t/TX1AytMWrpI2

Helpdesk
Creation date: 2/25/2021 9:20 AM      Updated: 11/7/2022 4:40 PM