Skip to content

Latest commit

 

History

History
35 lines (28 loc) · 1.29 KB

readme.md

File metadata and controls

35 lines (28 loc) · 1.29 KB
Raw

Google Cloud Event Certificate Generator

This repo simply use a template certificate docx file and generates certificates both docx and pdf.

Run these 4 commands in your terminal

git clone https://github.com/Sabyasachi-Seal/GCP-Certificate
cd GCP-Certificate

Now Copy your progress report to the Data Folder and rename it as ParticipantList.csv

pip install -r requirements.txt
python main_certificate.py

Customization

  • You can change the certificate template file in the Data folder.
  • You can change the email template file in the Data folder.

How to send emails?

Using Macros

  • You can use the Mail.xlms file to send emails to the participants. Open this with Excel. Press Allow Content if required.
  • Do not need to change anything in the file itself.
  • All you need to do is to search for View Macros in excel and then select the Send_Mails macro and then click on Run.
  • Now open outlook and login.
  • Click on outbox and see the mails being sent one by one.

Using SMTP with python

  • Run the send_mail.py script inside the Data folder
  • Enter your email and password
  • If any error raises saying that couldn't login or password is wrong, go to Manage your account in your gmail and enable Less secure app access.