Can Mail Merge do multiple records on one page in MS Word

Рет қаралды 118,646

Күн бұрын

Are you trying to do a mail merge in Microsoft Word to fit multiple records on one page? (Perhaps you are designing name tags or labels for an event). Here is how you do it!

Пікірлер: 60

@landonthings 2 жыл бұрын

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

@darinanderson1138 Жыл бұрын

I have been trying to figure this out for years. Thank you so much for posting this video.

@abcdefg8102 2 жыл бұрын

This is the best tutorial ever. Thank you. You are heaven sent.

@JaimePaz 8 ай бұрын

Thank you SO MUCH, I've been searching for that for years!

@sarahkathleen6752 Жыл бұрын

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

@Itsmeamarachi 7 күн бұрын

you are so iconic for this. THANK YOU!

@abelnyamori 2 жыл бұрын

Fantastic video. You saved me tons of work!

@sandeepkundra7070 2 жыл бұрын

Nice, very helpful in working out how to put multiple records on the same page.

@rosebarbett1250 8 ай бұрын

Thank you! This was extremely helpful and saved me so much time. 🙂

@minecraftjohn727 Жыл бұрын

This is what I've been looking for.

@bolivianracing 10 ай бұрын

Great solution, what i was looking for, thank you!

@joe77992 27 күн бұрын

Worked like a charm

@deltayakee 2 ай бұрын

Exactly what i needed thank you!

@sagit93 3 жыл бұрын

Hi, thank you for your video. It helps me a lot. Great video btw. 👍

@konstantinoskom5594 Жыл бұрын

You Sir are an amazing man!! You saved me gozlion of time wasted!!! Thank you so much appreciated!!

@benwilliams3311 Жыл бұрын

Thanks for posting, really helpful :)

@jitesh334 5 ай бұрын

really it was time saving bro..

@zelle2 4 ай бұрын

thank you! this was exactly what i needed to know :)

@neliatecson4884 3 жыл бұрын

Thank you, very helpful.😊

@tayyab1234598 Жыл бұрын

Worderful. You are really a great help!

@user-qk7bs4rm2u 7 ай бұрын

Great help! Thank you!

@ashuqhussainfakhri9004 Жыл бұрын

Thank you for this video!

@silentlips1837 3 жыл бұрын

Thankuhh Ur video really help me❤️

@crystalll6848 6 ай бұрын

really helpful! thx a lot!!

@acedelacruz9680 2 жыл бұрын

Thank you for your help I am really looking for this tutorial

@sikhosikhaobyyogesh8070 2 жыл бұрын

Thanks it's useful for me

@courtneyjackson8102 2 жыл бұрын

Thank you for this!

@s.sammaralizaidi1144 3 жыл бұрын

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?

@MasBa-ID 2 жыл бұрын

thank you sir, you save me 😁👍

@joelmorabang4764 Жыл бұрын

You deserve my sub brother

@nanyixing9654 3 жыл бұрын

Thanks a lot!

@abdullakooheji 3 ай бұрын

Thank you for that.

@ElliotKwan 2 жыл бұрын

does this work for text boxes? I'm making a custom look and I don't think a table would work

@sandeepm6751 2 жыл бұрын

Thank you Sir

@genesismacedo7953 3 жыл бұрын

Thank you

@unknwn_usr3077 Жыл бұрын

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

@MDSajib-jq2dl Жыл бұрын

Thanks sir.

@sdsdarulfalah1408 2 жыл бұрын

Thank you!

@bccsivxx-xxivvii 6 ай бұрын

Is there a way to auto size text so it shrinks to fit a set cell size?

@mykasstoriestotell8433 2 жыл бұрын

Hello if ever i try the next record and then preview the results then i dont see anything it is just blanks

@phatoudom2600 3 жыл бұрын

thank u sir

@amirmahdi9993 3 жыл бұрын

thanks a lot

@muriel2771 Жыл бұрын

THANK YOU!!!!

@denysuhendraproject5251 4 ай бұрын

thank you

@deveshkumarsharma843 2 жыл бұрын

I want next record in same column. When column complete, next column, please help me

@raulalvarez5128 10 ай бұрын

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?

@rebootedplayers9045 4 ай бұрын

Can you please share how can we arrange data vertically rather than horizontally value

@ChaveraCharif 3 жыл бұрын

but what if you only want everyone at magic monk at one page and everyone in a specific company in their own page?

@jamieballard6223 3 жыл бұрын

I'm not 100% positive but I think if you set it up in excel the way you want it you should be fine.

@bongbap 2 жыл бұрын

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).