Mail Merge is a powerful script designed to streamline your email communication process. With this tool, you can effortlessly send personalized emails along with attached documents in PDF format to a large number of recipients listed in your Excel or Spreadsheet. This script is not only easy to use but also completely free, allowing you to send emails with unlimited tokens. Say goodbye to manual email sending and enjoy the efficiency of Mail Merge for all your bulk email needs.
Demo.webm
-
Clone this repo.
-
Open App Script in your browser and sign in to start a new code session.
-
Open Excel in Google Docs.
-
Upload the sample spreadsheet to your Google Spreadsheet page.
-
Upload the sample documents to your Google Docs page.
-
Edit all the details except the "Email Sent" cell; leave that cell blank.
- After filling in the details, open the Extensions menu and click on App Script.
- Paste the content of the Mail_Merge.gs file here. It will look something like this:
-
Click on Save Project.
-
Run the code.
-
Click on Review Permissions.
-
Authorize the request, click on "Go to Untitled project (unsafe)," and then click on Allow.
-
A pop-up will appear in your Google Spreadsheet page. Add the sample document URL in the pop-up.
-
A second pop-up will appear in your Google Spreadsheet page. Add the Excel page URL in the pop-up.
-
Check your email. The email should have been sent by now.
-
Leave the "Email Sent" Cell Blank: Ensure the "Email Sent" cell is left blank before running the script to avoid errors.
-
Fill the Email Cells Correctly: Make sure that the "to_Email" and "my_email" cells are filled correctly with the recipient's and your email addresses.
-
Use the Same Google Account: Verify that the code and documents are under the same Google account by accessing the App Script page from the Excel page's Extensions tab.