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

Поділитися
Вставка
  • Опубліковано 18 лис 2024

КОМЕНТАРІ • 109

  • @raquelcapuras9
    @raquelcapuras9 7 місяців тому +1

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

  • @loratorrefranca9146
    @loratorrefranca9146 Рік тому

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

  • @arceliebacton7136
    @arceliebacton7136 Місяць тому

    Thanks a lot. This is so easy to follow.

  • @jessajavier9828
    @jessajavier9828 3 місяці тому

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

  • @sta.isabelelem.schooldipol5108
    @sta.isabelelem.schooldipol5108 2 роки тому

    thank you po sir, mas dali ko pong naintindihan.

  • @DeBooMeR
    @DeBooMeR 2 роки тому

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

  • @geraldinegurubat6665
    @geraldinegurubat6665 3 роки тому +2

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

  • @hmasna
    @hmasna 2 роки тому

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

  • @arlenemendoza2501
    @arlenemendoza2501 2 місяці тому

    thansk for sharing,a great help for me

  • @raquelsantos7762
    @raquelsantos7762 2 роки тому

    thank po sir, malaking tulong po itong share nyo

  • @bibiyahera8398
    @bibiyahera8398 2 роки тому

    I am very glad that I stumbled upon your video

  • @lemuelps
    @lemuelps 3 роки тому

    Galing working by following those steps

  • @jhunkolpo1984
    @jhunkolpo1984 3 роки тому

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

  • @itsnikay2710
    @itsnikay2710 3 роки тому

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

  • @markmendozadevera6407
    @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.

  • @abbemariah9537
    @abbemariah9537 Рік тому

    Ang galing sirrr salamat po

  • @mycacatibo8303
    @mycacatibo8303 3 роки тому

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

  • @ramosangelr.4033
    @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🥰

  • @donaldsumarana1013
    @donaldsumarana1013 2 роки тому

    Thank you sir😊 God bless po

  • @reynigalvez8223
    @reynigalvez8223 7 місяців тому

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

  • @dennisgrollo-vz5lb
    @dennisgrollo-vz5lb Рік тому

    Thank you sir this helps a lot

  • @toniobars9420
    @toniobars9420 3 роки тому

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

  • @rowenabeltran7261
    @rowenabeltran7261 3 роки тому

    Thank you very much po. This helped a lot.

  • @sciencekwela7776
    @sciencekwela7776 4 роки тому

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

  • @anezkailocso369
    @anezkailocso369 3 роки тому

    thnk you sir..very informative po

  • @rannielaayumi2445
    @rannielaayumi2445 3 роки тому

    Marami pong salamat!

  • @sabbathkeepershorts
    @sabbathkeepershorts 2 роки тому

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

  • @ten-tenchingu2192
    @ten-tenchingu2192 3 роки тому

    Thank you sir! Pinaka madaling instruction!

  • @abuhayyanabdullah7371
    @abuhayyanabdullah7371 3 місяці тому

    salamat din po ng marami

  • @beshibheb
    @beshibheb 4 роки тому

    Husay! New knowledge! Thanks sir!

  • @kenroldandiamante2706
    @kenroldandiamante2706 2 роки тому

    Thank you, sir!

  • @ginalynallen7398
    @ginalynallen7398 3 роки тому +2

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

  • @jesonv.siblag2530
    @jesonv.siblag2530 3 роки тому

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

  • @rodolfogolbin9410
    @rodolfogolbin9410 3 роки тому

    Thank you sir for this tutorial.

  • @zechnasffot
    @zechnasffot 2 роки тому

    Thanks for this!

  • @PepTwo
    @PepTwo 2 роки тому

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

  • @monskyreacts6450
    @monskyreacts6450 2 роки тому

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

  • @floriecapistrano9414
    @floriecapistrano9414 2 роки тому

    Thank you po sir 😊

  • @angelilao4299
    @angelilao4299 3 роки тому

    SUPER HELPFUL THANK YOU PO!!

  • @bonabacud9086
    @bonabacud9086 4 роки тому

    Thank you po Sir Louie,stay safe and healthy

  • @ma.jesusajimenez8994
    @ma.jesusajimenez8994 3 роки тому

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

  • @vinceiancanete6545
    @vinceiancanete6545 3 роки тому

    Great! Thanks Sir Louie!

  • @klaidu_
    @klaidu_ 2 роки тому

    Salamat po!

  • @carledamigo4194
    @carledamigo4194 3 роки тому

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

  • @marjorievarron5323
    @marjorievarron5323 2 роки тому

    Thank you so much po for this ❤️

  • @JONAS-be2uf
    @JONAS-be2uf 3 роки тому

    Thank you so much Sir Louie!

  • @teachermarkiebekekangsavie5320
    @teachermarkiebekekangsavie5320 4 роки тому

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

  • @aaa-kf5ko
    @aaa-kf5ko Рік тому

    Salamat po..

  • @concepcioncampomanes3306
    @concepcioncampomanes3306 2 роки тому

    Thank you .

  • @bonabacud561
    @bonabacud561 4 роки тому

    Thank you po Sir Louie

  • @teachersimonette1191
    @teachersimonette1191 3 роки тому

    Thanks Sir Louie

  • @sheilamaereyes-danez7196
    @sheilamaereyes-danez7196 2 місяці тому

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

  • @nikoru8367
    @nikoru8367 3 роки тому +1

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

  • @mayjeanmanigos268
    @mayjeanmanigos268 3 роки тому

    THANK YOU

  • @princessdaelim2818
    @princessdaelim2818 3 роки тому

    thank you po..

  • @LilyGutzMixVlog
    @LilyGutzMixVlog 3 роки тому

    Thank you sir

  • @chingsanchez198
    @chingsanchez198 4 роки тому

    AAAHHH! THANK YOUUU!

  • @davenemesismariano3370
    @davenemesismariano3370 3 роки тому

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

  • @merliedurana3232
    @merliedurana3232 8 місяців тому

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

  • @zhandsepe2011
    @zhandsepe2011 Рік тому +2

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

  • @zandymairecorbeta4195
    @zandymairecorbeta4195 3 роки тому

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

  • @gracereturada7802
    @gracereturada7802 2 роки тому

    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.

  • @IglotDelarosa
    @IglotDelarosa 6 місяців тому

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

  • @ierolldonneredfrancisco2131
    @ierolldonneredfrancisco2131 4 роки тому

    Shout out po sa next vlog sir

  • @maribethcasanova7314
    @maribethcasanova7314 3 роки тому

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

  • @alexamandalones79
    @alexamandalones79 Рік тому

    Anu pong gamit nyo screen recording sir?

  • @mariaalmaadriano8363
    @mariaalmaadriano8363 Місяць тому

    how about kung lagyan ng average or iba pang data

  • @beshibheb
    @beshibheb 4 роки тому +2

    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.

  • @benchmacalalad3505
    @benchmacalalad3505 3 роки тому

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

  • @johnrussellbarrientos6324
    @johnrussellbarrientos6324 2 роки тому

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

  • @greysa1303
    @greysa1303 3 роки тому

    Paano po yan maiisave individual file per each student

  • @patrishagalang1438
    @patrishagalang1438 2 роки тому

    what if po 2 columns yung page sa word

  • @enzogalia4914
    @enzogalia4914 3 роки тому

    Tnx sir

  • @zestmar3185
    @zestmar3185 2 місяці тому

    What if there are 2 fields?

  • @SSOBofficial
    @SSOBofficial 2 роки тому

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

  • @otakudesu9901
    @otakudesu9901 2 роки тому

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

  • @MisterMeyhn94
    @MisterMeyhn94 Рік тому

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

  • @ricoadfam8979
    @ricoadfam8979 3 роки тому

    Sir pwede po b yan gawin sa Phone?thanks

  • @moises5719
    @moises5719 Рік тому

    pwede din po ba yan sa power point

  • @dre.9207
    @dre.9207 3 роки тому

    Sir alam nyopoba kung pano sa mobile ung ganyan

  • @YouTuber10111
    @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.

  • @cristybadellaput4836
    @cristybadellaput4836 3 роки тому

    Anong size niya. Sir

  • @deusmachina3121
    @deusmachina3121 2 роки тому

    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
      @SirLouieTV  2 роки тому +1

      yes po :)

    • @deusmachina3121
      @deusmachina3121 2 роки тому

      @@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
    @inamaweee 3 роки тому

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

  • @stormrussell5670
    @stormrussell5670 2 роки тому

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

  • @gamertzy151
    @gamertzy151 2 роки тому

    Lezgo

  • @scoutergen-worldwide
    @scoutergen-worldwide 3 роки тому

    pwde ba ito sir sa Publisher?

  • @charizzeabalona2347
    @charizzeabalona2347 3 роки тому

    Good day. Pano po isave ng individual pdf people

    • @SirLouieTV
      @SirLouieTV  3 роки тому

      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
    @leslieannconsolacion1483 4 роки тому +1

    Pwede po ba ito sa ms publisher sir?

    • @SirLouieTV
      @SirLouieTV  4 роки тому +2

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

    • @leslieannconsolacion1483
      @leslieannconsolacion1483 4 роки тому

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

  • @beshibheb
    @beshibheb 4 роки тому

    Is it available for all MS Word version?

    • @SirLouieTV
      @SirLouieTV  4 роки тому +1

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

  • @demgarcia3695
    @demgarcia3695 4 роки тому

    Saan po galing ang format ser tnx po

    • @SirLouieTV
      @SirLouieTV  4 роки тому +1

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

  • @johnnyplays1927
    @johnnyplays1927 4 місяці тому

    Thanks po sa tutorial malaking tulong talaga.

  • @randypialamanilao980
    @randypialamanilao980 2 роки тому

    Thanks sir Louie