How to create and run mail merges in Google Docs?

To create and run mail merges in Google Docs, follow these steps:

  1. Open a new Google Docs document.
  2. Click on "Add-ons" in the menu bar.
  3. Select "Get add-ons" from the dropdown menu.
  4. Search for "Yet Another Mail Merge" in the Add-ons marketplace.
  5. Click on "Install" and grant the necessary permissions.
  6. Once installed, a new "Yet Another Mail Merge" option will appear under the "Add-ons" menu.
  7. Prepare your data source in Google Sheets. Each column represents a merge field (e.g., First Name, Last Name, Email).
  8. Open a new Google Sheets document and enter the data for your mail merge recipients.
  9. In the Google Docs document, type out your email template, leaving placeholders (placeholders are the merge fields that will be automatically filled in for each recipient).
  10. Click on "Add-ons" followed by "Yet Another Mail Merge" and select "Start Mail Merge."
  11. Choose your data source (the Google Sheets document with recipient data).
  12. Select the merge fields from the first row of your data source.
  13. Preview your email to ensure the merge fields are correctly inserted.
  14. Click on "Send Emails" to send personalized emails to each recipient.

Note: Yet Another Mail Merge allows you to send a certain number of emails per day for free. If you need to send more emails, you may need to upgrade to a paid version or explore other mail merging add-ons in the marketplace.