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.
Don't have Microsoft Office? Mail Merge for free using WPS Office: • How to Mail Merge in W...
As full disclosure, I work at Microsoft.

[@tiisetsomajoe2501]

❤❤❤❤❤ you’ve just rescued me from typing 200 certificates from scratch! Thank you 🙏🏾

[@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?

[@BethToups]

Thank you for breaking it down into simple to follow steps. I got this now!

[@shawalras]

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

[@mjmeternal2696]

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

[@Hell_AntoNY]

Great brother. Job done. Thanks for letting us know

[@sathsaraniashinsha1234]

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

[@leninawright8516]

This was so very helpful and precise!!! THANK YOU!!!!!!!!!!

[@syedirshaan3005]

excellent explanation. Thanks and love from India

[@marieemaina21]

So helpful. Straight to the point

[@emmaeroseclairerollon610]

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

[@kellyshepherd836]

Thank you....this was excellent explanation!

[@cortexconsulting5986]

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

[@ravigoswamigoogle]

Yes, you can send with GiveMyCertificate plateform

[@matthewmoore4986]

Very Help. Well organized.

[@jasonj5579]

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

[@zanderrazo4443]

Thank you for such informative video.

[@balajidelta]

How do you split the individual certificates as a separate file

[@dinafrancisco8237]

You can get them in an individual file by printing each page to a .pdf .

[@dougrobbins5699]

Use the Merge to Individual Documents facility on my Merge Tools add in that Kevin demonstrates in kzbin.info/www/bejne/r5vCpGaZmcuJers

[@zakiachi]

@@dougrobbins5699 Hi is their a way to save individual certificates as a separate files. I don't want to mail them

[@dougrobbins5699]

@@zakiachi To create Individual Certificates, use the Merge to Individual Documents facility on my Merge Tools add in

[@simoneebanks8115]

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?

[@ningbo182]

I was using acrobat's word addin to do it.

[@xxes11xx]

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!

[@sanjusingha1714]

Question:- ABCD college is issuing certificates to 5 students who secured first, second and third positions in the college in the three courses- B.A(P), B.Sc(H), and B.Com(H). The data record (Student.xls) has the following fields: Name, Roll No, Course, and Position. Write steps to register the data source and issue the individual certificates using mail merge. The format of the letter is as follows: ABCD College Date: 21/11/2021 This is to certify that Mr./Ms. has secured in ABCD College. Principal ABCD College Plz make a video

[@ashikuzzamanabir2171]

Thanks dude. Really helpful.

[@brendamartinezgomez2297]

Very helpful. Thanks!

[@ZhwanShwany]

Thank you for the tutorial! Can you do a tutorial on how to create a certificate with a list of activities and credits earned for each activity, kind of like a report card?

[@julemarsabellano7504]

thank you! its very helpful

[@jeanpierresant1836]

Hello @kevin, excellent tutorial however when you go to print the certificate in pdf. instead of getting multiple pdfs, you get one pdf document with multiple certificates. I need them to be separate to be able to email them separately. Can you advise please?

[@margiebuela6345]

Thank you..well explained 👏👏👏

[@danwhitcombe4275]

Thanks for uploading this - is there a way to then export the individual certificates as individual files to then send to recipients (via WhatsApp)?

[@AutismSupportBC]

Is it possible to have emails as well on the spreadsheet and have outlook email each individual certificate with the relative name?

[@MukminunTV]

Kevin, How to print them in PDFs separately?

[@dinafrancisco8237]

Hey everyone, You can get them in an individual file by printing each page to a .pdf .

[@kasviniapmuniandymoe1496]

Extremely helpful.

[@GoldenHarvestQualityAssurance]

thanks for this tutorial, however the print to pdf gives you one pdf document with multiple certificates. how can i get each certificate in a different pdf file?

[@paulovisto6944]

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.

[@easyspeaking2u]

@KevinStratvert How can I do the mail merge for the certificates then send the individual certificates to the persons email...HELP

[@dougrobbins5699]

Use the Merge to Email as PDF Attachment destination on the Merge with Attachments facility on my Merge Tools add in that Kevin demonstrates in kzbin.info/www/bejne/r5vCpGaZmcuJers

[@zafariqbalkhan6279]

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?

[@dougrobbins5699]

Use the Merge to Email as PDF Attachment destination of the Merge with Attachments facility when you have the Certificate Mail Merge Main document as the active document.

[@ginasimmons897]

Can this be done using MSExcel and MSPowerpoint instead of MSWord?

[@sandyantor9234]

If I have a pdf certificate how do I get that file in word to start merge? 4 fields First name, last name, date, year? How does Microsoft word know where to place the four fields?

[@TVDramaHome]

Can we use Autosave with Mail Merge?

[@theresiaanggraini7338]

Thank you. Very useful

[@CatherineDeCanal]

Hi! Is there a workaround for graphics that become jumbled once opened in Word?

[@jackiet8908]

Hey - I wonder whether there is a way to send a pdf of a merged certificate by email. If I have 50 certificates and I am sending them by email, I need to email each one manually. Any ideas?

[@msvishal2868]

Exactly i am searching for same

[@msvishal2868]

There was a extension in google sheets named autocrat, but now its been removed.

[@AKMagician]

I have made a certificate on adobe illustrator. Now i have around 170 students. How can i write all their names on JPEG or PDF?

[@RyanJumarPantoja]

can you do mail merge this time the certificate is made on powerpoint?

[@chynanicolevia187]

Very helpful. Thanks! 😉❤

[@dinafrancisco8237]

Hey everyone, You can get them in an individual file by printing each page to a .pdf .

[@mubaseboi]

Hi Kevin, that's a great video. May i ask, now once you have printed the certificates to PDF, is there a way to merge them to an email with a list or participants I do realize i could do that by choosing email, and followed by attachment instead of print in the earlier step, however, it sends the attachment in a word file, would it be possible for me to send it as a PDF attachment right away? Thanks Kevin

[@KevinStratvert]

Hey Kavin - yes, it's possible to attach PDFs. The following video will help with this (it requires a free add-in): kzbin.info/www/bejne/r5vCpGaZmcuJers

[@teamtechenvironmenthealtha753]

@@KevinStratvert Thanks, Kevin. It's amazing that I could come across these videos at least. I have the same question as Kavin asks. I want to send such developed certificates directly from Microsoft publisher to individuals email as pdf attachments. Is there a better way than making a list of file location column in the excel file to send out this to individuals. I did watch your other video as well. So please guide if at all any option there without making an additional column and manual entry to the same. A lot many files to deal with ... in the case of making say 100-500 such files are not easy. looking forward to getting your response on this.

[@zakiachi]

@@KevinStratvert Hi kevin this video was very helpful. i just want to ask is their a way to save individual certificates as a separate files. I don't want to mail them. i just want save the certificates separately on my laptop

[@SuperMakadi]

Hello Kevin, How to send bulk e-mails with certificates.

[@TM-sb7nd]

How do I get the certificate image to cover the entire page if im inserting the picture

[@shazmashazma7099]

Hi Kevin Wanna say thanks and there's a suggestion could you please teach me how to create Link External link or internet Link

[@thirdsandaime9649]

Cool! But how could you print the file separately?

[@aideperez-pena7716]

How do you do it to include the signature? We are doing certificates for promotions.

[@nissarahmadaliyar482]

amazing. thank you.

[@oceano_queen]

How do I email the certificates to the recipients using mail merge? Is that possible?

[@MuzaffCraft]

THANK YOU !

[@amankushwaha8180]

what if i have maded certificate using canva and want to edit name how to do that????

[@marcchua7866]

I just saw this. Would there be a limit on how many certificates that we can send out using this?

[@dougrobbins5699]

The only limit would be any limit that is imposed by your mail service provider.

[@paidosas]

How do you email separately each certicicate to each recipient without doing manually????

[@amandeepthakur7847]

did you figured out this ? if yes plz, tell me also

[@jiyashah9194]

Thank you so much

[@elardartamus4488]

Very useful thanks

[@jasmines-n5126]

Really good video

[@BBTR6]

Thank you! :)

[@juandredavidtz9755]

Is there a way to save all the certificates as separate files ?

[@bollinger1000]

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

[@karendowhite5019]

KGD I have a list of names in excel and word. I have created a certificate in PowerPoint how do I mail merge the names to PPT?

[@dougrobbins5699]

Create the certificate in Word. Send a copy of the PowerPoint to me at [e-mail] if you need assistance with that.

[@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?

[@dougrobbins5699]

Better to include the names in the data source and use a mergefield in the mailmerge main document instead of a formfield.

[@sheikhirfan83]

Thanks mate

[@PreMathSci]

Dear Kevin, Is there any way to e-mail the PDF certificates at once?

[@dougrobbins5699]

Use the Merge to Email as PDF Attachment destination of the Merge with Attachments facility when you have the Certificate Mail Merge Main document as the active document.

[@PreMathSci]

@@dougrobbins5699 Thank you. I'll try it

[@mrjbalisong3589]

hi bro i saw your tutorial ... i was wondering could you teach me how to do it on 2 page per sheet on page set up when i save it goes blank on the page in pdf

[@mrjbalisong3589]

thx man for the tutorial i figure it already hahahahha GG

[@theunxor]

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

[@zeeshanjawaid6240]

how to import certificate design from Power Point 360 into Word 360 accurately ?

[@weaponsofpraisetv]

THANK YOU...‼️‼️‼️

[@zadewriterforhire6150]

I have done that. The question is, how do I send these certificates to each of the participants?

[@dougrobbins5699]

Use the Merge to Email as PDF Attachment destination of the Merge with Attachments facility when you have the Certificate Mail Merge Main document as the active document.

[@pavithramanikandan414]

Thank you

[@crazyvideos-y5n]

How to take print of merge one is there any page setup

[@gilbertturaray]

Hi Kevin, can I make a request< Can you upload a tutorial on how to use autocrat? Thank you and looking forward for your favorable response. God Bless

[@rajurajeshkumar]

Hi, I want video about mail merge with individual photos pls do that video if possible

[@foodshortsmanas]

Thanks, man

[@GAMERULTRON]

Thanks a lot

[@riffatjalil5800]

Can we merge certificates in jpeg template?

[@nazirkabbani]

Need this for powerpoint instead of word to create slides

[@dorinaonoya1965]

Thanks

[@laychannhan]

can you give me this form cirtificate ?

[@ChecheHerr]

Bulk mail I send out once a month for a bundle.

[@noorazeeliaabdulmanan786]

This tutorial ❤❤❤❤❤❤❤❤❤❤❤❤❤

[@issac.energy]

Thank bro :))

[@carlageee]

life saver

[@chansonang7581]

good

[@shull488]

Thank you. Very good information.