How to Mail Merge By Grouping Data Easily Multiple Records on Same Page

[@Rrr0948-x6o]

Thanks for the valuable information, It worked for me. Please keep up the good work.

[@HabibUllahqamar]

I am thankful to you sir. Salute

[@akshaynm]

Very Nice Tutorial Sir, Thanks a lot 🙏🏻

[@pkgoodfriend]

While entering bill no or value from mail merge you are getting data in {} and we are getting in , also after set id code if i am inserting amount it is becoming blank

[@Imrans8888]

Hi I have multiple products for one invoice how can I add that to mail merge invoices I tried using your formula and it's getting an error please can you help me out...

[@SaymaSultana-w9m]

How to send email to different people with this different grouping data table to those specific person? Please answer.

[@Vivacious197]

Hello Please I need help with this task and its urgent. I have a data sources(excel file) with variable length table i want to merge blocks of fields into a single word document and I don't know how to achieve this task

[@MrRavibains]

I doing the same, code disappear after i insert merged field and also data gets on repeated on second page also. On second page doesn't start from the next record but from second record. Please help

[@ramzanhabib5988]

Greetings sir can charts of excell be mail merged or not if yes plz guide me

[@shaheenmahmud5884]

Can you please help how can I get "same data table" in the multiple word pages

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

[@Islamic-Naats-n-Video-Channel]

MashaAllah U R Gem ❤️❤️❤️

[@PatriciaHall-r7f]

Can you provide the instructions on how to do this on a mac book?

[@RinkuSharma-2107]

Hi I have a one problems of mail merge. I use your this video but not find solutions of my problem. I have discussed with lots of IT professionals but not getting solution. Now you are my last hope. I am working in FMCG sector in supply chain and send to pending material details against my orders.currently i make filter and send data. And I have almost 1000 vendors and send mail in this manner can take 3-4 days. I want use email merge technique for this. I have multiple rows of one particular person and same email address of that. I use mail merge then mail goes against one row and I want one mail with multiple rows. Please help

[@villagesurveyor2949]

Sir , iam getting 0 after mail merge, when there is alphanumeric such as 1A, 2D in a cell, what to do sir , any solution

[@danielsandovalarias6192]

This is a really great video. I have to do something similar at my job, but the table that I have to attach in the body of the email is transposed. Which means that the Row 1 has all of my client's invoices (1 invoice per column), and in row 2 I have all of the amounts (one amount per column). Can I group records using the method explained in the video in my scenario? I've tried but it hasn't worked

[@deepakmutalik3788]

Hi Sir if I want to blank table then what is the code

[@StevenCollins093063]

This is a very nice way to handle this. I am having a problem where a given location has 5 items with a given value - similar to your example. It works on the "first page" of any multi-line where it meets the condition, however, it then recurses through them until it gets to the next description (i.e. 5 lines with 5 quantities, 4 lines with 4 quantities, 3 lines with 3 quantities, 2 lines with 2 quantities, 1 line with 1 quantity) and then moves to the next location. I've been through the code numerous times and can't seem to find the way out of it recursing through the data until it gets to the next location.

[@ethanhunt9764]

Similar problem. Any solution

[@najamaabbas]

Thank you, very helpful. I have a question though. Instead of an Invoice, I have a model number that could be the same among different customers. Is there any way to just set parameters on the customer name only?

[@KhurramKhanExcelLogic]

Group your data by Customer and apply same logic

[@najamaabbas]

@@KhurramKhanExcelLogic Thanks, I set the ID on the model number though. Regardless, it's working because I ensure the model number doesn't repeat in the first line when data is sorted by customer name.

[@najamaabbas]

@@KhurramKhanExcelLogic, I have one funny thing happening though. When I created copy for the new fiscal year. It populates data fine on the first letter but 2nd letter also shows for the same customer with one less record. For example, 1 customer has 4 records: First letter - 4 records (the way it should be) 2nd letter - 3 records (excluding 1st) 3rd Letter - 2 records (excluding above 2) 4th letter - 1 record (excluding above 3) Any idea why it might be happening?

[@najamaabbas]

@@KhurramKhanExcelLogic Never mind, thank you so much. It works perfectly. It's just not showing accurately if I see the preview.

[@SanjeevKumar-kt2ln]

good video but When I use SET ID "" it showing me blank cell

[@Pasuishero]

Press alt+F9

[@MrRavibains]

Same problem to me. When i insert merged field, code disappear

[@gopal398]

​@@Pasuisheroright

[@prasenjitchatterjee2787]

@khurram sir...aapse ek urgent help chahiye Ek mail merge banane ke liye....main aapse phone pe baat kar sakta hun kya??

[@Pasuishero]

Really helpful video

[@KhurramKhanExcelLogic]

Glad it was helpful!

[@allahnoortareen9747]

plz send a backup file so i will runt it myself perhaps your assistance will need in this regard

[@rohitnair474]

Hello sir, thank you for the video. Would you be able to help understand what needs to be done when data is not consistent. By that i mean, if one customer has more than 3 or 4 records and the next might have only 2 records. The data will change every time. Not sure how to deal with that.

[@srinifreezer]

Have you got the solution

[@dharmendratotla5192]

How to delete extra column named test which is displayed blank on every page after mail merge.

[@hareeshkota73]

Sor why ctrl+F9 is not working in ms office 2010

[@faridlalji3661]

Hi Khurram, i have used this. I am having an issue where it is creating a new letter for every single line in the excel spreadsheet. Can you help

[@KhurramKhanExcelLogic]

Do not preview it. Just finish Mail Merge. It should create new letter for each row.

[@faridlalji3661]

@@KhurramKhanExcelLogic Hi Khurram, still doesn’t do it. So I have say user 1 who has 5 peices of equipment listed in a spreadsheet, then user 2 may have 3 peices of equipment.

[@KhurramKhanExcelLogic]

I suggest to review your code, as in example discussed in video same customer has different rows and it work fine. Thanks

[@muhammadyounis2686]

nice info sir

[@shyamn7998]

if rows are dynamic not fixed then how we can do the mail merge.

[@chanelburgos984]

think you would just have to adjust your if statement formula in the excel test column

[@1987vishnu]

Individual mails are created for each records

[@achokderis5490]

Hi... the table 1 and table 2 have difference fields. for example table 1 for hobbies, table 2 for favourite foods. For example: Table 1: Ali's hobbies are playing basketball, table tennis, volleyball and rugby Table 2: Ali's favourite foods are chicken curry, satay, KFC and chicken burger. need help please

[@KhurramKhanExcelLogic]

Put the contents of both tables in one Row as a single record

[@achokderis5490]

It is already in one row record in excel. I mean the both table2 are in word.

[@achokderis5490]

@@KhurramKhanExcelLogic Hai have a good day, is it possible if the record (for example record2 for one person) have more than 1 row records (Field data - Name, course, date start, date end, appointment, year). Example: Michael had attended 3 courses with different date and had appointed in 4 appointments before. So it will have 3 rows data for Michael in Excel (courses) and 4 rows data for his appointments. Help me please. Thanks.

[@abhilashvictorgadde5018]

Sir please make another video for multiple rows of data in one page

[@rajarajan4985]

NOT WORKING INDUVIDUVAL PAGE CREATED IN SINGLE DATA

[@SiddhantRaiSK]

If clause is not working,

[@sankalpsrikrishna4794]

It is not working in 2007 version

[@dennisaikens1292]

Thanks for the video! I have a slight problem. My data set includes the person's name, their ID number, a course name, a course code, and a due date for each name. The first document for each name has all of the correct information. However, let's say John Doe has 4 courses to his name. After the 1st page, each subsequent page will included one less course name until it gets to only one course. Then a new page will start with the next name and so on and so forth. If I group the records by name, what code would I use for that? Set ID1 and ID2 as the person's name? [Edit:] Tried that and it made a sheet for each course name.

[@achokderis5490]

how to mergemail from multiple record excel to 2 tables in word on sama page?? help me please

[@KhurramKhanExcelLogic]

If you have two tables in a word document. You can insert your merge fields in the required tables.

[@KhurramKhanExcelLogic]

If you have two tables in a word document. You can insert your merge fields in the required tables.

[@achokderis5490]

@@KhurramKhanExcelLogic for the table no2, first line it show the data but second line it doesn't appear

[@achokderis5490]

the table 1 and table 2 have difference fields. for example table 1 for hobbies, table 2 for favourite foods. help me please

[@achokderis5490]

For example: Table 1: Ali's hobbies are playing basketball, table tennis, volleyball and rugby Table 2: Ali's favourite foods are chicken curry, satay, KFC and chicken burger.

[@jangkhopaobaite5656]

how to mail merge multiple Marks eg- Half yearly Mark and Final Marks in ms word in one page

[@rahulbisht7392]

Why it's not working for me

[@KhurramKhanExcelLogic]

Don't preview, just finish Mail Merge and see Merged file

[@elizabethrowbottom383]

I really wish this was in English. I have been trying to do this with out any luck for weeks.

[@KhurramKhanExcelLogic]

You can find one video on this topic in English on my channel

[@motussss5123]

{ Set ID1 "yaha insert field karta hu to Pura code vanish ho jata hai"}

[@KhurramKhanExcelLogic]

Try Alt F9, it is used for debugging. Press Alt F9 to see control code and press it again to see the output of code

[@st.andrewsc.s.ichurchkanum7746]

@@KhurramKhanExcelLogic AFTER USING ALT F9 IT GETTING VISIBLE BUT NOT WORKING

[@achokderis5490]

Hi

[@TJAMALENTERTAINMENT]

Aoa Sir H r u

[@KhurramKhanExcelLogic]

I am good, thanks