HOW TO CREATE BULK CERTIFICATES IN 4 EASY STEPS | Microsoft Office Mail Merge (Tagalog) [TUTORIAL]

[@geraldinegurubat6665]

Thank you so much po sir! You save me huhu kasi una ko ginagawa iniisa isa ko talaga siya copy and paste kaya buong ko ginawa yung 256 na certificates. Nung natapos na ako naconvert ko na siya in pdf don ko napansin na mali pala yung format na ginawa ko dapat pala naka capitalize lahat ng names. Kaya maraming salamat!!!!

[@raquelcapuras9]

Very simple instruction for non technical individual like me...thank you for sharing ❤

[@DeBooMeR]

sheesh anlaking tulong po neto especially for national and other big events hosted by some random college students hahaha salamat po

[@loratorrefranca9146]

Thank you sir. Nakagawa na ako ng mga certificates. God bless!!!

[@sta.isabelelem.schooldipol5108]

thank you po sir, mas dali ko pong naintindihan.

[@lemuelps]

Galing working by following those steps

[@bibiyahera8398]

I am very glad that I stumbled upon your video

[@markmendozadevera6407]

Thank you very much for this, Teacher Louie! I had to refresh myself on how to use mail merge. This video helped a lot.

[@sciencekwela7776]

hahaha ngayon ko lang nadiscover to. Very useful po, Sir. Thanks

[@SirLouieTV]

thank you po sir!

[@arceliebacton7136]

Thanks a lot. This is so easy to follow.

[@jessajavier9828]

Very useful po talaga nitong video mo sir, Salamat po!!!!

[@reynigalvez8223]

Maraming salamat po sa tulong, gaya ko po ako lang mag isa lahat gumawa

[@ramosangelr.4033]

Hi sir thank you for this informative video ,this will very a big help for me and to my work. More videos and content like this po.GODBLESS PO🥰

[@mycacatibo8303]

Thank po sir you help me a lot. You make my Work easier and Faster.

[@hmasna]

Thank you po sa tutorial ninyo, Sir! Bagong tuklas na karunungan! ❤️❤️❤️

[@raquelsantos7762]

thank po sir, malaking tulong po itong share nyo

[@itsnikay2710]

Thank you sir. Nagamit ko po ito and it really works 🙏🏻

[@jhunkolpo1984]

Thank you sir..malaking tulong po ito. Godbless po.

[@arlenemendoza2501]

thansk for sharing,a great help for me

[@ginalynallen7398]

Thankyou Sir so helpful for us Teachers. This is what i really need. New subscriber here. Good job po.

[@Monsky07]

Galing mo sir. This is what I'm lookin' for. :)

[@abbemariah9537]

Ang galing sirrr salamat po

[@jesonv.siblag2530]

Galing naman po. Salamat po master. Teacher vlogger din ako from deped R6

[@dennisgrollo-vz5lb]

Thank you sir this helps a lot

[@rowenabeltran7261]

Thank you very much po. This helped a lot.

[@sabbathkeepershorts]

Huge help, thank you so much for this video tutorial Sir!

[@donaldsumarana1013]

Thank you sir😊 God bless po

[@toniobars9420]

I love it.. easy steps.. well explained... i love it

[@abuhayyanabdullah7371]

salamat din po ng marami

[@ten-tenchingu2192]

Thank you sir! Pinaka madaling instruction!

[@anezkailocso369]

thnk you sir..very informative po

[@beshibheb]

Husay! New knowledge! Thanks sir!

[@SirLouieTV]

thank you po!

[@PepTwo]

Great video, easy to understand with the English subtitle. Thank you

[@ZionCynilSarte]

Salamat sirrrr

[@kenroldandiamante2706]

Thank you, sir!

[@rodolfogolbin9410]

Thank you sir for this tutorial.

[@zechnasffot]

Thanks for this!

[@angelilao4299]

SUPER HELPFUL THANK YOU PO!!

[@rannielaayumi2445]

Marami pong salamat!

[@vinceiancanete6545]

Great! Thanks Sir Louie!

[@bonabacud9086]

Thank you po Sir Louie,stay safe and healthy

[@floriecapistrano9414]

Thank you po sir 😊

[@JONAS-be2uf]

Thank you so much Sir Louie!

[@ma.jesusajimenez8994]

Thank you po sir! Well explained! 😊 God bless 🙏

[@marjorievarron5323]

Thank you so much po for this ❤️

[@teachermarkiebekekangsavie5320]

Thank you sir, I've learned a lot po sa inyong mga videos🥰

[@concepcioncampomanes3306]

Thank you .

[@aaa-kf5ko]

Salamat po..

[@teachersimonette1191]

Thanks Sir Louie

[@klaidu_]

Salamat po!

[@carledamigo4194]

Sir salamat sana madami pa kayo gawin na tagalog version, mas madali masundan

[@bonabacud561]

Thank you po Sir Louie

[@chingsanchez198]

AAAHHH! THANK YOUUU!

[@mayjeanmanigos268]

THANK YOU

[@ierolldonneredfrancisco2131]

Shout out po sa next vlog sir

[@SirLouieTV]

hahaha thank you Ieroll!

[@LilyGutzMixVlog]

Thank you sir

[@princessdaelim2818]

thank you po..

[@randybiago2612]

What theme fonts and number use for example Certification of Priest,thank you

[@nikoru8367]

thank you po, sir for this content!! big help po for my subject na empowerment technologies. god bless po, sir and more contents and powers to come ^^

[@beshibheb]

Hi Sir! Ask ko lang po. What if sa PowerPoint ako gumawa ng certificate layout, meron din bang mail merge dun? I used PowerPoint para maconvert ko siya into jpeg format for virtual certificates.

[@merliedurana3232]

sir, pano po kung may idagdag "CPA license number. di po lahat ay CPA so yung iba wala CPA license number

[@enzogalia4914]

Tnx sir

[@leoneletada9521]

Sir, saan po dapat ginawa ang template, pwede po ba sa Word? Thank you

[@jruss24]

Pwede mo ba iexport as individual jpeg file tas naka filename sa name ng cert recipient>?

[@zandymairecorbeta4195]

Thank you, sir. Pero pano din po kapag dalawa yung dapat ilagay sa cert? Yung name at tsaka yung LRN nila po?

[@misamisorientalnationalhig7457]

ty

[@maribethcasanova7314]

Thank you po dito sir. Possible po ba na picture ng certificate na nakapng format ang gamitin layout ng cert?

[@gamertzy151]

Lezgo

[@zhandsepe2011]

Hello Sir Louie thank you for the tutorial video and the new learning. I followed your tutorial with 7 variables considered and it works except for the average grade. The average grade in the generated certificates would not appear as desired. I set the average grade in 2 decimal places in excel but in the generated certificates it would appear in different decimal places. Do you have idea how to set it so that it will appear in 2 decimal places? Thank you...

[@SirLouieTV]

hello po! kindly check the decimal format in MS Excel. It should be rounded of to two decimal places (used the ROUND formula/function). If you just used the adjust decimal places button (increase/decimal buttons) it will still show the actual decimal places when transferred to MS Word

[@alexamandalones79]

Anu pong gamit nyo screen recording sir?

[@MisterMeyhn94]

Good day automatic po ba to mag create ng certificates based sa number ng list?

[@otakudesu9901]

Ask lang po. Need po ba madami na copy ng bawat cert. Tapos automatic na papasok dun ung name?

[@patrishagalang1438]

what if po 2 columns yung page sa word

[@IglotDelarosa]

hi, how to save it individually to PDF file po?

[@mariaalmaadriano8363]

how about kung lagyan ng average or iba pang data

[@greysa1303]

Paano po yan maiisave individual file per each student

[@gracereturada7802]

Thank you for imparting good tips in preparing various certificates. May i know what will be the process if aside from nanes i still need to include number of modules being evaluated for 2 semesters and add QR code. Thank you again.

[@sheilamaereyes-danez7196]

A blessed day! Paano po paggamit Publisher? for student ID

[@deusmachina3121]

Isang page ng certificate layout lang po ba ang kailangan? Then siya na po ba bahalang magreproduce ng layout base sa bilang ng recipients?

[@SirLouieTV]

yes po :)

[@deusmachina3121]

@@SirLouieTV thanks po Sir, tamang tama po ito, I’m serving as a secretariat po kasi sa isang workshop and seminar ng mga Brgy. officials, 200+ participants din yun, thanks pp ulit

[@inamaweee]

Paano po pag dalawang cert sa isang bondpaper? I tried already po pero yung isang cert lang na-iinput ng names po eh

[@geraldinegurubat6665]

Burahin niyo po yung extra na page

[@davenemesismariano3370]

thank you so much po! paano naman po yung may "his and her" sa certificate?

[@ricoadfam8979]

Sir pwede po b yan gawin sa Phone?thanks

[@SSOBofficial]

thanks sir pa request naman po pag gawa ng i.d via ms word po

[@moises5719]

pwede din po ba yan sa power point

[@zestmar3185]

What if there are 2 fields?

[@YouTuber10111]

ask ko lang po sir, paano po gawin yung certificate in 2 columns po para po sana di masyadong malaki sa bond paper po para sa mga participants na nag attend ng seminar. kumbaga po 2 certificate in 1 bond paper ganun po sana, half ng bond paper. paano po gawin sa ms word? SANA PO MA BASA NIYO TO PO, Thank you po.

[@kepino6038]

Same question hehehe

[@stormrussell5670]

Pwd bng dalawa ang heading na ilalagay? For example ay may name and LRN?

[@SirLouieTV]

yes po, pwede po

[@benchmacalalad3505]

Sir san po nakakakita ng boarder ng mga cerificates..yun po simple lang.thank u sir..more power

[@dre.9207]

Sir alam nyopoba kung pano sa mobile ung ganyan

[@charizzeabalona2347]

Good day. Pano po isave ng individual pdf people

[@SirLouieTV]

hello po! may mga websites po tayong owedeng puntahan to convert the PDF File to individual PDFs :) Example po ito: smallpdf.com/split-pdf

[@leslieannconsolacion1483]

Pwede po ba ito sa ms publisher sir?

[@SirLouieTV]

yes po, mayroon din pong Mail Merge sa MS Publisher :) same procedure lang din po

[@leslieannconsolacion1483]

@@SirLouieTV thank you sir.. more power 👍😊

[@cristybadellaput4836]

Anong size niya. Sir

[@scoutergen-worldwide]

pwde ba ito sir sa Publisher?

[@beshibheb]

Is it available for all MS Word version?

[@SirLouieTV]

yes po :) kahit yung mga lumang versions meron din nung Mail Merge :)

[@demgarcia3695]

Saan po galing ang format ser tnx po

[@SirLouieTV]

yan po yung dating layout po ng school namin sir :)

[@johnnyplays1927]

Thanks po sa tutorial malaking tulong talaga.

[@randypialamanilao980]

Thanks sir Louie