Create a mail merge using Gmail and Google Sheets

Create a mail merge using Gmail and Google Sheets

What is a mail merge?

A mail merge is a method of taking data from a database, spreadsheet, or other form of structured data, and inserting it into documents such as letters, mailing labels, and name tags. It usually requires two files, one storing the variable data to be inserted, and the other containing both the instructions for formatting the variable data and the information that will be identical across each result of the mail merge.

You can also print a set of mailing labels or envelopes by doing a mail merge. For labels, you would construct a source document containing the addresses of the people you wish to print labels for and a main document that controls where each person's name, address, city, state, and zip code will go on the label. The main document would also contain information about how many labels are on a page, the size of each label, the size of the sheet of paper the labels are attached to, and the type of printer you will use to print the labels. Running a mail merge with the two files results in a set of labels, one for each entry in the source document, with each label formatted according to the information in the main document.

What is Google Sheets?

Google Sheets is a free, web-based spreadsheet application that is provided by Google within the Google Drive service. The application is also available as a desktop application on ChromeOS, and as a mobile app on Android, Windows, iOS, and BlackBerry. The Google Drive service also hosts other Google products such as Google Docs, Slides, and Forms.

Features of Google Sheets

1. Editing

One of the key features of Google Sheets is that it allows collaborative editing of spreadsheets in real-time. Rather than emailing one document to multiple people, a single document can be opened and edited by multiple users simultaneously. Users can see every change made by other collaborators, and all changes are automatically saved to Google servers.

Google Sheets also includes a sidebar chat feature that allows collaborators to discuss edits in real-time and make recommendations on certain changes. Any changes that the collaborators make can be tracked using the Revision History feature. An editor can review past edits and revert any unwanted changes.

Supported file formats

Google Sheets supports multiple spreadsheet file formats and file types. Users can open, edit, save or export spreadsheets and document files into Google Sheets. Some of the formats that can be viewed and converted to Google Sheets include

.xlsx
.xls
.xlsm
.xlt
.xltx
.odt
.csv
.tsv

Please Watching My Video is Below

Design by Vannak Vannaro