The YAMM Blog - Tips and tricks to email more productively

Create and send pre-filled Google Forms with Google Sheets

Learn how to create pre-filled Google Froms with Google Sheets data to save people from entering data they already gave you previously.

6 min read Oct 28, 2021

Google Sheets public

Send out Google Classroom Enrollment Codes using VLOOKUP and YAMM

Learn how to use VLOOKUP and YAMM to send mail merges

6 min read Oct 20, 2021

Google Sheets public

Create and Delete Dropdown Lists in Google Sheets using Data Validation

A detailed tutorial on how to create and use options dropdown in Google Sheets cells, with data validation

3 min read Sep 8, 2021

Google Sheets public

Find and remove duplicates in Google Sheets

In this post, I will show you how to quickly find and remove duplicates in Google Sheets.

6 min read Jul 27, 2021

Google Apps Script public

Create Calendar Events with Google Meet links using the Calendar API and Google Apps Script

Welcome to the second part of the Calendar API Tutorial Series. In this blog, I am going to show you…

4 min read Jul 15, 2021

Google Apps Script public

Get Calendar Events into your Spreadsheet using the Calendar API and Google Apps Script

In this blog, I am going to show you how to create calendar events from a Google Sheet using the Calendar API and Google Apps Script.

5 min read Jul 7, 2021

compliance public

Yet Another Mail Merge earns iKeepSafe COPPA and FERPA certifications

By getting independently certified, YAMM is providing validation that its products fit into K12 programs from a security standpoint. These certifications prove Talarian’s products follow the requirements set forth by FERPA and COPPA.

3 min read Jun 15, 2021

Google Sheets public

9 useful formulas for Google Sheets

Formulas we will cover: SPLIT JOIN FILTER COUNTA SPARKLINE DETECTLANGUAGE GOOGLETRANSLATE IMPORTRANGE CHAR(8226)

8 min read Jun 14, 2021

Google Sheets public

Extract cell notes using Google Apps Script

In this blog, I am going to show you how to extract cell notes into another column using Google Apps…

3 min read Jun 9, 2021

Google Sheets public

Create Filters in Google Sheet using Google Apps Script

Google Sheets provides a filtering function. However, using Google Apps Script to filter data will automate the process, make it faster to apply on various data sets.

5 min read May 31, 2021

Gmail public

3 steps to create beautiful and engaging emails with Google Docs

Learn to create beautiful emails in Google Docs with advanced formatting, headers, margins, and footers

7 min read May 10, 2021

Gmail public

Add another email address to Gmail (works with Outlook and Hotmail)

Add another email address to Gmail and use your Outlook or Hotmail account to send email from within Gmail

4 min read May 7, 2021

The Yet Another Mail Merge Blog