How To Mail Merge In Google Docs?

To know how to mail merge in Google Docs, carry out the step-by-step guidelines given below.

  • Step 1: Write a message that you need to send on Google Docs as a template.
  • Step 2: Create a spreadsheet on your Google Sheet, click the Insert tab, and choose the Script option.
  • Step 3: Type autocrat in the search bar and click the Search button.
  • Step 4: On the search result appears on the screen, click the Install option next to the Autocrat script.
  • Step 5: If the Authenticate Required dialog box opens, select the Authenticate option and click the Accept option.
  • Step 6: Click the Autocrat tab and choose the Run Initial Configuration option.
  • Step 7: Select the Choose template from device option, choose the created mail merge document, and click the Save Settings option.
  • Step 8: Click the Save option in the ‘Select Merge Data Source’ dialog box.
  • Step 9: Fill the required fields and click the Submit option in the Set Merge Conditions dialog box.
  • Step 10: Provide valid details in both the Set field mappings and Set merge type dialog boxes.
  • Step 11: Now, you have completed the Autocrat script configuration.
  • Step 12: When the Preview/Run Merge dialog box appears on the screen, select the Run the Merge option.
  • Step 13: Once done with the merging process, exit the Autocrat window.
  • Step 14: You will see the results on the Spreadsheet after the mail merging process.
  • Step 15:By using these steps we can execute that how to mail merge in Google Docs.