Microsoft Learn Student Ambassador Certificate Generator

Use it now: https://mlsa-certificate-generator.iamseal.tech/

(Only follow the instructions below if you are generating manually)

Check out this video below:

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

Working on Windows only.

Run these commands in your terminal

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

Now Copy your Participant List to the Data Folder and rename it as ParticipantList.csv.
The list must have the following fields: Name, Email. It may have more, but these 2 are essential.

pip install -r requirements.txt
python main_certificate.py

Important

Do not use this button to run your code:

Use `python main_certificate.py` to run your code

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?

You can use the Mail.xlsm 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.

Further Releases (Planning)

Implementing for Linux users?

Souce Repo(I made some subtle improvements) : Click Here

adityaSkhorne2401/Certificate-Generator-MLSA