This was by far the best video I’ve found on the topic. So well done, great narration and I love your character in the lower corner. 10/10 recommend!!!
@darinanderson11382 жыл бұрын
I have been trying to figure this out for years. Thank you so much for posting this video.
@JaimePaz Жыл бұрын
Thank you SO MUCH, I've been searching for that for years!
@abcdefg81022 жыл бұрын
This is the best tutorial ever. Thank you. You are heaven sent.
@minecraftjohn727 Жыл бұрын
This is what I've been looking for.
@ero-senninsama17342 ай бұрын
Very useful, I use it to make a list of information. Saves me a lot of time
@magicmonk2 ай бұрын
Glad it was helpful!
@RiseMovie-hw7qkАй бұрын
10 out of 10 stars great tnks upload this video
@sarahkathleen67522 жыл бұрын
Thank you for this video! Saved me a ton of time. You also explained this in a really clear and easy to understand way. Thank you!! :)
@Itsmeamarachi4 ай бұрын
you are so iconic for this. THANK YOU!
@rosebarbett1250 Жыл бұрын
Thank you! This was extremely helpful and saved me so much time. 🙂
@deltayakee6 ай бұрын
Exactly what i needed thank you!
@bolivianracing Жыл бұрын
Great solution, what i was looking for, thank you!
@konstantinoskom55942 жыл бұрын
You Sir are an amazing man!! You saved me gozlion of time wasted!!! Thank you so much appreciated!!
@jitesh3349 ай бұрын
really it was time saving bro..
@joe779925 ай бұрын
Worked like a charm
@zelle28 ай бұрын
thank you! this was exactly what i needed to know :)
@abelnyamori2 жыл бұрын
Fantastic video. You saved me tons of work!
@MelvinJohnson-s2f Жыл бұрын
Great help! Thank you!
@s.sammaralizaidi11443 жыл бұрын
I have some queries: Q1. Why you created multiple pages when you are doing mail merge? if you already created multiple pages then what is the use of mail merge? Q2. when I creat single page and start mail merger some records duplicates?
@ashuqhussainfakhri90042 жыл бұрын
Thank you for this video!
@abdullakooheji7 ай бұрын
Thank you for that.
@sandeepkundra70702 жыл бұрын
Nice, very helpful in working out how to put multiple records on the same page.
@sikhosikhaobyyogesh80703 жыл бұрын
Thanks it's useful for me
@benwilliams33112 жыл бұрын
Thanks for posting, really helpful :)
@tayyab12345982 жыл бұрын
Worderful. You are really a great help!
@joelmorabang47642 жыл бұрын
You deserve my sub brother
@courtneyjackson81022 жыл бұрын
Thank you for this!
@ChaveraCharif3 жыл бұрын
but what if you only want everyone at magic monk at one page and everyone in a specific company in their own page?
@jamieballard62233 жыл бұрын
I'm not 100% positive but I think if you set it up in excel the way you want it you should be fine.
@bongbap3 жыл бұрын
I manually do so by manually set a limit of the number of records per page, and list all records that I want to be in one page in one row. E.g. I create a template consist of Company Name and a table of 5 rows. Then in file Data there will be 11 columns: company name, first name_r1, last name_r1, first name_r2, last name_r2,... and so on; leave the columns without people empty (sorting will help grouping people of the same company together, then cut paste). So after mail merging, I have one page with Magic Monk together with 2 rows with name and 3 empty rows, the next page has Mars together with 1 row with name and 4 empty rows. If there are more than 5 people in a same company then I need to set the rest in another row for another page though. I'm not satisfy with it, but at least it's a workaround. Or you can make use of the Next Record method in this video with empty rows and manual marking (preset number of records per page; sorting in Data; set people in the same company with marks: 1_1, 1_2,...; use IF function to create another table consisting all marks: 1_1, 1_2,.., 1_5, 2_1,.., 2_5, 3_1,...; use VLOOKUP to fill in the new table based on the marks; mail merge using the new table).
@sandeepm67513 жыл бұрын
Thank you Sir
@neliatecson48843 жыл бұрын
Thank you, very helpful.😊
@sdsdarulfalah14082 жыл бұрын
Thank you!
@ElliotKwan2 жыл бұрын
does this work for text boxes? I'm making a custom look and I don't think a table would work
@MasBa-ID3 жыл бұрын
thank you sir, you save me 😁👍
@acedelacruz96803 жыл бұрын
Thank you for your help I am really looking for this tutorial
@silentlips18373 жыл бұрын
Thankuhh Ur video really help me❤️
@nanyixing96543 жыл бұрын
Thanks a lot!
@unknwn_usr30772 жыл бұрын
Hey, I'm trying to make a marksheet using mail merge.. but there is one issue. There are Six subjects and the condition is - least marks scored by the student is not calculated for Percentage and that subject is supposed to be in the last row. How can I do that? All the data is ready but when mail merging, the subject row wont be static and will be different for each student depending on the marks scored. Plz help
@bccsivxx-xxivvii10 ай бұрын
Is there a way to auto size text so it shrinks to fit a set cell size?
@muriel27712 жыл бұрын
THANK YOU!!!!
@amirmahdi99933 жыл бұрын
thanks a lot
@sagit934 жыл бұрын
Hi, thank you for your video. It helps me a lot. Great video btw. 👍
@genesismacedo79534 жыл бұрын
Thank you
@rebootedplayers90458 ай бұрын
Can you please share how can we arrange data vertically rather than horizontally value
@mykasstoriestotell84333 жыл бұрын
Hello if ever i try the next record and then preview the results then i dont see anything it is just blanks
@raulalvarez5128 Жыл бұрын
When I use multiple names on one page, then tend to repeat and shift when I add a second page. How do I correct it so it doesnt shift?
@phatoudom26003 жыл бұрын
thank u sir
@deveshkumarsharma8433 жыл бұрын
I want next record in same column. When column complete, next column, please help me
@DJ-lw3nv2 жыл бұрын
Would it be possible to leave out the prelude to the tutorial?
@nilofarnisha57422 жыл бұрын
SSIR, HOW CAN I PUT MULTIPLE ADRESS IN PULTIPLE PAGES
@Jakeu1701 Жыл бұрын
You only need to define one page and it will continue creating them through the mailing list file.
@jangkhopaobaite56562 жыл бұрын
How to mail merge two excel sheet in one ms word
@newgame9093 жыл бұрын
Anyone else surprised by the accent? Lol. Helpful vid though