How to mail merge from google sheets

Mailing merging from Google Sheets! Here's a step-by-step guide to help you achieve this:

Prerequisites:

You have a Google Sheet with a list of data (e.g., names, addresses, emails, etc.).
You have a document (e.g., Google Docs, Microsoft Word, or PDF) that you want to mail merge with your Google Sheet data.

Method 1: Using Google Sheets' built-in Mail Merge feature (for Google Docs only)

Open your Google Sheet and select the range of cells that contains the data you want to mail merge.
Go to the "Tools" menu and select "Mail Merge".
Choose the document type (e.g., Google Doc) and select the document you want to mail merge.
In the "Mail Merge" window, select the data range you selected in step 1.
Choose the merge fields (e.g., names, addresses, emails) and click "Merge".
Google Sheets will create a new document with the merged data.

Method 2: Using Google Apps Script (for any document type)

Open your Google Sheet and select the range of cells that contains the data you want to mail merge.
Go to the "Tools" menu and select "Script editor".
In the script editor, create a new script by clicking on the "Create" button.

Paste the following code:


function mailMerge() {
var sheet = SpreadsheetApp.getActiveSheet();
var dataRange = sheet.getRange("A1:E10"); // adjust the range to your data
var data = dataRange.getValues();
var doc = DocumentApp.openById("your-document-id"); // replace with your document ID
var body = doc.getBody();

for (var i = 0; i < data.length; i++) { var row = data[i]; body.replaceText("{{name}}", row[0]); body.replaceText("{{address}}", row[1]); // add more merge fields as needed } doc.saveAndClose(); }


5. Replace "your-document-id" with the ID of your document.
6. Save the script by clicking on the floppy disk icon or pressing Ctrl+S (or Cmd+S on a Mac).
7. Go back to your Google Sheet and click on the "Run" button (or press Ctrl+Enter or Cmd+Enter) to execute the script.
8. The script will create a new document with the merged data.

**Method 3: Using a third-party add-on (e.g., AutoCrat, Mail Merge)**

1. Install a mail merge add-on from the Google Workspace Marketplace (e.g., AutoCrat, Mail Merge).
2. Follow the add-on's instructions to set up the mail merge process.

Remember to adjust the script code or add-on settings according to your specific needs and document type. Happy mail merging!

Mail Knowledge

How to mail merge from google sheets