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

[@raquelcapuras9]

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

[@arceliebacton7136]

Thanks a lot. This is so easy to follow.

[@loratorrefranca9146]

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

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

[@bibiyahera8398]

I am very glad that I stumbled upon your video

[@lemuelps]

Galing working by following those steps

[@mycacatibo8303]

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

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

[@hmasna]

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

[@toniobars9420]

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

[@arlenemendoza2501]

thansk for sharing,a great help for me

[@jessajavier9828]

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

[@DeBooMeR]

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

[@johnnyplays1927]

Thanks po sa tutorial malaking tulong talaga.

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

[@rowenabeltran7261]

Thank you very much po. This helped a lot.

[@sta.isabelelem.schooldipol5108]

thank you po sir, mas dali ko pong naintindihan.

[@sabbathkeepershorts]

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

[@donaldsumarana1013]

Thank you sir😊 God bless po

[@dennisgrollo-vz5lb]

Thank you sir this helps a lot

[@itsnikay2710]

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

[@monskyreacts6450]

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

[@raquelsantos7762]

thank po sir, malaking tulong po itong share nyo

[@anezkailocso369]

thnk you sir..very informative po

[@beshibheb]

Husay! New knowledge! Thanks sir!

[@SirLouieTV]

thank you po!

[@abbemariah9537]

Ang galing sirrr salamat po

[@ten-tenchingu2192]

Thank you sir! Pinaka madaling instruction!

[@sciencekwela7776]

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

[@SirLouieTV]

thank you po sir!

[@angelilao4299]

SUPER HELPFUL THANK YOU PO!!

[@kenroldandiamante2706]

Thank you, sir!

[@ginalynallen7398]

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

[@zechnasffot]

Thanks for this!

[@reynigalvez8223]

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

[@rodolfogolbin9410]

Thank you sir for this tutorial.

[@vinceiancanete6545]

Great! Thanks Sir Louie!

[@PepTwo]

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

[@ma.jesusajimenez8994]

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

[@floriecapistrano9414]

Thank you po sir 😊

[@marjorievarron5323]

Thank you so much po for this ❤️

[@JONAS-be2uf]

Thank you so much Sir Louie!

[@rannielaayumi2445]

Marami pong salamat!

[@bonabacud9086]

Thank you po Sir Louie,stay safe and healthy

[@jesonv.siblag2530]

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

[@randypialamanilao980]

Thanks sir Louie

[@abuhayyanabdullah7371]

salamat din po ng marami

[@teachermarkiebekekangsavie5320]

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

[@bonabacud561]

Thank you po Sir Louie

[@concepcioncampomanes3306]

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 ^^

[@chingsanchez198]

AAAHHH! THANK YOUUU!

[@carledamigo4194]

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

[@klaidu_]

Salamat po!

[@ierolldonneredfrancisco2131]

Shout out po sa next vlog sir

[@SirLouieTV]

hahaha thank you Ieroll!

[@aaa-kf5ko]

Salamat po..

[@princessdaelim2818]

thank you po..

[@mayjeanmanigos268]

THANK YOU

[@LilyGutzMixVlog]

Thank you sir

[@sheilamaereyes-danez7196]

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

[@enzogalia4914]

Tnx sir

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

[@alexamandalones79]

Anu pong gamit nyo screen recording sir?

[@zandymairecorbeta4195]

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

[@SSOBofficial]

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

[@maribethcasanova7314]

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

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

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

[@davenemesismariano3370]

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

[@gamertzy151]

Lezgo

[@johnrussellbarrientos6324]

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

[@misamisorientalnationalhig7457]

ty

[@benchmacalalad3505]

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

[@merliedurana3232]

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

[@IglotDelarosa]

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

[@otakudesu9901]

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

[@ricoadfam8979]

Sir pwede po b yan gawin sa Phone?thanks

[@MisterMeyhn94]

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

[@mariaalmaadriano8363]

how about kung lagyan ng average or iba pang data

[@patrishagalang1438]

what if po 2 columns yung page sa word

[@greysa1303]

Paano po yan maiisave individual file per each student

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

[@moises5719]

pwede din po ba yan sa power point

[@dre.9207]

Sir alam nyopoba kung pano sa mobile ung ganyan

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

[@beshibheb]

Is it available for all MS Word version?

[@SirLouieTV]

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

[@scoutergen-worldwide]

pwde ba ito sir sa Publisher?

[@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 👍😊

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

[@cristybadellaput4836]

Anong size niya. Sir

[@demgarcia3695]

Saan po galing ang format ser tnx po

[@SirLouieTV]

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

[@jhunkolpo1984]

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

[@teachersimonette1191]

Thanks Sir Louie