Why does mail merge skip records

The 3rd record has the score from Row 5 and it is duplicated on the 4th record. I have a setup a bit like what you are after, I will add it as an image, to see if it helps. I believe that the info I need on the mail merge is right at my fingertips and unfortunately I am not able to click on your image to expand it. Hello Raymond. Thank you for the work you have put into answering my question on mail merge.

Unfortunately I am not able to click on your image and I believe that would answer my problem if I could see your image. I too cannot click on the image. Trying to print 4 documents to a page in Word going into the print options and selecting 4 per page just prints 1 record in the top corner and the rest are blank.

Thanks so much for this tutorial. This is exactly the information that I was looking for, I shall try it out now and get my mail campaign together. Many thanks again! This is great — I have one other query though.

I am making raffle tickets and have to a page, but on subsequent pages it goes back to the second value. For example: I have ticket number , , on page one and then page two goes , , … how can I keep it going consecutively? I too was going by the merge preview, and it looked like my records were duplicating. But when I actually ran the merge to a new document, they all came out only once and in sequence. Thank you so much for posting this!!! I had the same problem with student cards.

I designed a full page student card and merged it to my students list. I finished the merge and clicked edit individual document and selected all.

When this is complete I clicked file then print and chosen 8 pages per sheet. Try it. I added a "test" record to the beginning of the list, and when I merged to a document, 3 records were still missing, but the last record that was previously missing now appears, and the record immeidately before the one that was previously missing is now missing. By the way, this same problem happens whether I use a word document as the data source, or, as I tried yesterday, exported it to an excel spreadsheet and use that as the source.

Any more thoughts? Doug Robbins. Search results for 'Why is my merge skipping records? Sequence Skipping started UTC. Monika Krug UTC. Peter Jamieson UTC. Gary Lee UTC. Doug Robbins UTC. Click Edit Merge Document. Make the appropriate changes.

On your Word document, highlight the field you want to populate with the data from Excel. On the Mailings tab, choose the 'Insert Merge Field' button, a list of the column headers on your saved excel document will drop down i. Company Name, etc. Choose the appropriate field you want to merge and choose Insert. The root cause of the " skipping " behavior during a Mass Mail Merge for labels, is an improperly formatted MS Word document that is used as the source for the Mail Merge template.

Having multiple copies of the same merge field on the same page can cause the first record to be repeated in all instances of the merge field on that page. Use a Next Record rule beside each instance of the merge field that you want Word to move to the next record.

This will force Word to go to the next record. Main page Questions categories Philosophy and history Common philosophy Philosophy in education Philosophy and sociology Philosophy edu Students info Common articles Best philosophy topics.

Take a look at the similar writing assignments Essay Is merged a word? Get a writing assignment done or a free consulting with qualified academic writer. Read also What is an antonym for fruitful? I set up a Libre text document with the template for Avery Address labels, 30 per page. I eventually found out that each missing label was the 31st, 61st, and 91st label in the list - basically skipping a label every time it starts a new page of labels.

You might want to check that by looking at the form with field names displayed cntrl-F9. That did the trick. Thanks a million, JohnD! I have a large spreadsheet of names and addresses; a mailing list.