❤❤❤❤❤ you’ve just rescued me from typing 200 certificates from scratch! Thank you 🙏🏾
@MrMariodelicata Жыл бұрын
Excellent tutorial. Short , simple and straight to the point.
@elyu_vibes4 жыл бұрын
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?
@BethToups2 ай бұрын
Thank you for breaking it down into simple to follow steps. I got this now!
@shawalras3 жыл бұрын
This is great. Been cracking my head about this for a week now. Thanks!
@mjmeternal26963 жыл бұрын
I knew this but then I forgot it. Thanks for reminding me. You're thebest brother
@Hell_AntoNY25 күн бұрын
Great brother. Job done. Thanks for letting us know
@sathsaraniashinsha12342 жыл бұрын
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
@emmaeroseclairerollon6104 жыл бұрын
thank you Mr. Stratvert for a better explaination. :)
@kellyshepherd8364 жыл бұрын
Thank you....this was excellent explanation!
@cortexconsulting59863 жыл бұрын
Q: how do I create bulk certificates and email them all at once ? I can't seem to figure that out. Thanks!!!
@ravigoswamigoogle2 жыл бұрын
Yes, you can send with GiveMyCertificate plateform
@matthewmoore49864 жыл бұрын
Very Help. Well organized.
@jasonj55792 жыл бұрын
er, how if i want it to be separated certs?
@zanderrazo4443 Жыл бұрын
Thank you for such informative video.
@balajidelta4 жыл бұрын
How do you split the individual certificates as a separate file
@dinafrancisco82373 жыл бұрын
You can get them in an individual file by printing each page to a .pdf .
@dougrobbins56993 жыл бұрын
Use the Merge to Individual Documents facility on my Merge Tools add in that Kevin demonstrates in kzbin.info/www/bejne/r5vCpGaZmcuJers
@zakiachi3 жыл бұрын
@@dougrobbins5699 Hi is their a way to save individual certificates as a separate files. I don't want to mail them
@dougrobbins56993 жыл бұрын
@@zakiachi To create Individual Certificates, use the Merge to Individual Documents facility on my Merge Tools add in
@simoneebanks81154 жыл бұрын
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?
@ningbo1824 жыл бұрын
I was using acrobat's word addin to do it.
@xxes11xx4 жыл бұрын
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!
@sanjusingha17142 жыл бұрын
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
@ashikuzzamanabir21712 жыл бұрын
Thanks dude. Really helpful.
@brendamartinezgomez2297 Жыл бұрын
Very helpful. Thanks!
@ZhwanShwany8 ай бұрын
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?
@julemarsabellano75048 ай бұрын
thank you! its very helpful
@jeanpierresant18364 ай бұрын
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?
@margiebuela63454 жыл бұрын
Thank you..well explained 👏👏👏
@danwhitcombe42757 ай бұрын
Thanks for uploading this - is there a way to then export the individual certificates as individual files to then send to recipients (via WhatsApp)?
@AutismSupportBC13 күн бұрын
Is it possible to have emails as well on the spreadsheet and have outlook email each individual certificate with the relative name?
@MukminunTV4 жыл бұрын
Kevin, How to print them in PDFs separately?
@dinafrancisco82373 жыл бұрын
Hey everyone, You can get them in an individual file by printing each page to a .pdf .
@kasviniapmuniandymoe1496 Жыл бұрын
Extremely helpful.
@GoldenHarvestQualityAssurance4 ай бұрын
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?
@paulovisto69444 жыл бұрын
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.
@easyspeaking2u4 жыл бұрын
@KevinStratvert How can I do the mail merge for the certificates then send the individual certificates to the persons email...HELP
@dougrobbins56993 жыл бұрын
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
@zafariqbalkhan62793 жыл бұрын
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?
@dougrobbins56993 жыл бұрын
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.
@ginasimmons8976 ай бұрын
Can this be done using MSExcel and MSPowerpoint instead of MSWord?
@sandyantor92343 жыл бұрын
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?
@TVDramaHome3 жыл бұрын
Can we use Autosave with Mail Merge?
@theresiaanggraini73383 жыл бұрын
Thank you. Very useful
@CatherineDeCanal8 ай бұрын
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.
@AKMagician3 жыл бұрын
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?
@RyanJumarPantoja4 күн бұрын
can you do mail merge this time the certificate is made on powerpoint?
@chynanicolevia1873 жыл бұрын
Very helpful. Thanks! 😉❤
@dinafrancisco82373 жыл бұрын
Hey everyone, You can get them in an individual file by printing each page to a .pdf .
@mubaseboi4 жыл бұрын
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
@KevinStratvert4 жыл бұрын
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
@teamtechenvironmenthealtha7534 жыл бұрын
@@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.
@zakiachi3 жыл бұрын
@@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
@SuperMakadi2 жыл бұрын
Hello Kevin, How to send bulk e-mails with certificates.
@TM-sb7nd4 ай бұрын
How do I get the certificate image to cover the entire page if im inserting the picture
@shazmashazma70992 жыл бұрын
Hi Kevin Wanna say thanks and there's a suggestion could you please teach me how to create Link External link or internet Link
@thirdsandaime96494 жыл бұрын
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.
@nissarahmadaliyar4827 ай бұрын
amazing. thank you.
@oceano_queen2 жыл бұрын
How do I email the certificates to the recipients using mail merge? Is that possible?
@MuzaffCraft3 жыл бұрын
THANK YOU !
@amankushwaha81802 жыл бұрын
what if i have maded certificate using canva and want to edit name how to do that????
@marcchua78663 жыл бұрын
I just saw this. Would there be a limit on how many certificates that we can send out using this?
@dougrobbins56993 жыл бұрын
The only limit would be any limit that is imposed by your mail service provider.
@paidosas4 жыл бұрын
How do you email separately each certicicate to each recipient without doing manually????
@amandeepthakur78473 жыл бұрын
did you figured out this ? if yes plz, tell me also
@jiyashah91942 жыл бұрын
Thank you so much
@elardartamus44884 жыл бұрын
Very useful thanks
@jasmines-n51264 жыл бұрын
Really good video
@BBTR6 Жыл бұрын
Thank you! :)
@juandredavidtz975511 ай бұрын
Is there a way to save all the certificates as separate files ?
@bollinger10004 жыл бұрын
please can you do a vid showing how to mail merge labels using the latest version of ms word for mac.
@karendowhite50193 жыл бұрын
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?
@dougrobbins56993 жыл бұрын
Create the certificate in Word. Send a copy of the PowerPoint to me at dougrobbinsmvp@gmail.com if you need assistance with that.
@sciphan3 жыл бұрын
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?
@dougrobbins56993 жыл бұрын
Better to include the names in the data source and use a mergefield in the mailmerge main document instead of a formfield.
@sheikhirfan833 жыл бұрын
Thanks mate
@PreMathSci3 жыл бұрын
Dear Kevin, Is there any way to e-mail the PDF certificates at once?
@dougrobbins56993 жыл бұрын
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.
@PreMathSci3 жыл бұрын
@@dougrobbins5699 Thank you. I'll try it
@mrjbalisong35893 жыл бұрын
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
@mrjbalisong35893 жыл бұрын
thx man for the tutorial i figure it already hahahahha GG
@theunxor3 жыл бұрын
Save as .jpg/.png/any picture formats, instead of export (in my case, exporting disappears the names)
@zeeshanjawaid62404 жыл бұрын
how to import certificate design from Power Point 360 into Word 360 accurately ?
@weaponsofpraisetv11 ай бұрын
THANK YOU...‼️‼️‼️
@zadewriterforhire61503 жыл бұрын
I have done that. The question is, how do I send these certificates to each of the participants?
@dougrobbins56993 жыл бұрын
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-y5n10 ай бұрын
How to take print of merge one is there any page setup
@gilbertturaray4 жыл бұрын
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
@rajurajeshkumar3 жыл бұрын
Hi, I want video about mail merge with individual photos pls do that video if possible
@foodshortsmanas3 жыл бұрын
Thanks, man
@GAMERULTRON3 жыл бұрын
Thanks a lot
@riffatjalil58003 жыл бұрын
Can we merge certificates in jpeg template?
@nazirkabbani2 жыл бұрын
Need this for powerpoint instead of word to create slides