Create Certificates and Mail Merge
商店資訊更新日期:2024年4月25日
適用裝置:
4萬+
總覽
Make Certificate and Mail Merge in your domain.

This add-on will enable the user to create a CERTIFICATE to the number of users based on the given spreadsheet and template slide. The prepared certificates will be stored in the Google Drive inside the created folder with e-mailing them as pdf to each user. Or you can only save them in your google drive without e-mailing them if you did not specify an e-mail address.

You can add various details to the certificate from a spreadsheet columns. This includes:

 Full Name, 
 Course Code, 
 Exam Score,
 E-mail Address,
 Month

Prepare the Spreadsheet Columns as:
 
Full Name	Exam Score	E-mail Address	Course Code  Month

Set the name of the first sheet as Sheet1 and the second sheet as Email Template
																		
You need to add the required field in the template slide as:
{{FullName}}
{{CourseCode}} 
{{ExamScore}}
{{Month}}


To send a subject and body mail, then all you need is to put them in cell A1 of the second sheet (Email Template) , you can add the name of the user as ${"Full Name"}.

Updates (v3):
Create another folder for saving copies of the certificates as pdf.

Updates (v2):
you can write your E-mail template in the way you want. 
You can prepare your certificates and send them by e-mail and save the copy in your Google drive Or you can only save them in Google drive without sending any e-mail, if there's no written e-mail address. 

This is a spreadsheet add-on, that means using the CertiMerge can be done by installing the add-on using a spreadsheet. 
其他資訊
定價未提供
開發人員
CertiMerge 將會要求下方所示的權限。瞭解詳情
CertiMerge 將需要存取您的 Google 帳戶
這項操作將授予「CertiMerge」下列權限:
查看、編輯、建立及刪除您的所有 Google 文件檔案
查看、編輯、建立及刪除您的所有 Google 雲端硬碟檔案
查看及管理您在 Google 雲端硬碟中的表單
查看、編輯、建立及刪除您的所有 Google 簡報檔案
查看、編輯、建立及刪除您的所有 Google 試算表檔案
以您的身分傳送電子郵件
查看您的主要 Google 帳戶電子郵件地址
查看您的個人資訊,包括您已公開的任何個人資訊
評論
語言:
排序依據:
Google 不會驗證評論或評分。 進一步瞭解評論內容
沒有留言
搜尋
清除搜尋內容
關閉搜尋
Google 應用程式
主選單