/Mailman

Allows Google Sheets users to send formatted emails. The key difference between Mailman and other mail merge add-ons is Mailman allows you to set conditions for whether an email should be sent.

Primary LanguageJavaScriptGNU General Public License v3.0GPL-3.0

Mailman

Mailman aims to make sending emails easy. Using common spreadsheet functions, customize when you want to send your emails. A powerful, easy to use mail merge solution for the City of Edmonton. Mailman guides you through the process of setting up your own mail merge. Just use our merge tags! You can use <<>> to swap out data from your Google Sheets into your emails. Supercharge your email workflow today!

Collaborate

Is Mailman missing a feature you need? Let us know by filling this Google Form out. After ~20 minutes, it should show up in Mailman's issue tracker.

Features

  • quickly set up email campaigns
  • use Google Sheets functions to determine when to send your emails
  • send up to 1500 emails per day
  • store and reuse merge templates for future use
  • create advanced bug trackers, inventory managers and more

Dev Setup

UI Layer

  • VSCode is recommended: https://code.visualstudio.com/
  • Open the following folder in VSCode: {mailman_repo}/src/Mailman.Server/ClientApp
  • Run the "start web" task (in the menu select Terminal->Run task...)
  • Open the Apps script project deployed when you ran "clasp push"
  • Run the Apps script project as a Test Add-On
  • Happy Coding :) Any changes to the files in VSCode will automatically cause the add-on to refresh with the updated changes