How to Mail Merge Certificates - Office 365

Learn how to Mail Merge to create customized certificates using Microsoft Word and Excel. Quickly take a spreadsheet with names and create many customized certificates with ease. No need to paste individual names, and other information into a certificate.

Mail Merge allows you to send customized envelopes, letters, certificates, and emails. Mail Merge leverages Microsoft Word and Excel.

As full disclosure, I work at Microsoft.

[shawalras]

This is great. Been cracking my head about this for a week now. Thanks!

[MrMariodelicata]

Excellent tutorial. Short, simple and straight to the point.

[elyu_vibes]

Hi Kevin! This is so great! Assuming my data source includes their email addresses. Is there an option to automate to send the generated certificates to their respective email addresses?

[mjmeternal]

I knew this but then I forgot it. Thanks for reminding me. You're thebest brother

[leninawright]

This was so very helpful and precise!!! THANK

[kellyshepherd]

Thank you....this was excellent explanation!

[sathsaraniashinsha]

Thank you for creating such a video it is very worth to me because I follow a CAA course

[xxesxx]

Could you do one like this for PPT + Excel? I've only seen very crazy cases with coding to be done by the user, and that terrifies me.... I've created a beuatiful PPT certificate, now I want to make my life easier when inputting the names. Thank you very much!

[emmaeroseclairerollon]

thank you Mr. Stratvert for a better explaination. :)

[simoneebanks]

Thank you Kevin.

I found this very helpful. Is there a way that the certificates could be converted to pdf when emailed as an attachment by mail merge?

[jasonj]

er, how if i want it to be separated certs?

[thirdsandaime]

Cool! But how could you print the file separately?

[paulovisto]

Good day Sir Kevin, can you help me on how to mail a bunch of email address with different name and attachment using Gmail. The attachment is a certificate of participation with names. Thank you in advance.

[cortexconsulting]

Q: how do I create bulk certificates and email them all at once ? I can't seem to figure that out. Thanks!!!

[syedirshaan]

excellent explanation. Thanks and love from India

[bollinger]

please can you do a vid showing how to mail merge labels using the latest version of ms word for mac.

[theunxor]

Save as .jpg/.png/any picture formats, instead of export (in my case, exporting disappears the names)

[odaamargaa]

would share how to design the certificate you are showing. or put the template for download,

[zafariqbalkhan]

Dear Kevin, Thanks a lot for this and lot of other tutorials you share, I just want to know if there is a way, we can email these Certificates to recipients as PDF in the attachment?

[sciphan]

Hey man, your videos have been super helpful, but I have a question. Is there a way to do the Mail Merge function on a certificate that has a form field for the name but the rest of the document is edit-protected?