This repo simply use a template certificate docx file and generates certificates both docx and pdf.
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
- You can change the certificate template file in the
Data
folder. - You can change the email template file in the
Data
folder.
- You can use the
Mail.xlms
file to send emails to the participants. Open this with Excel. PressAllow 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 theSend_Mails
macro and then click onRun
. - Now open outlook and login.
- Click on outbox and see the mails being sent one by one.
- 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 enableLess secure app access
.