I have created a raffle ticket for my sons band 50/50 raffle and an excel file for the numbers to be generated. I can get the numbers generated on the tickets and stubs, but the number on the ticket do not match with the stub. They are one number off. Any ideas what I may have done wrong.



50-50 Raffle - Ticket numbers.xlsx

50-50 Raffle1 - Merged.docx

There are a number of issues, the most significant being that you have apparently set this up as a Letters merge, but the merge document has more than one page. It should have only one page and no Next record field in the last cell of that page.

You have also omitted a header row in your worksheet. Create a header row - call it 'Numbers' and change the merge fields to reflect that.

The attached is a rebuilt version and it should merge correctly when you attach the data source (also attached).

Attached Files

	Ticket Merge.docx (111.0 KB, 12 views)
	50-50 Raffle - Ticket numbers.xlsx (12.0 KB, 13 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks Graham,

That is all I had wrong, multiple pages in the ticket and no header on the spreadsheet? Did you change the merge type? How did you get <<NUMBERS>> to be the place marker? Did you just manually edit the pre-generated place marker?

I can see what you changed visually. I just can't see what was changed on the merge. I want to be able to recreate it, if I design another ticket.

Thanks again.

Edit: I copied and pasted the the first page of my original ticket into a new document and I see how you got the place marker to display <<NUMBERS>> now that I added the header field to my original spreadsheet. But I still have the mismatch.

The merge was recreated using the elements from your table in a new table with the correct merge fields inserted. The error in yours probably relates to the nested tables confusing the merge.

You might find it simpler to have a one row table, with no 'Next Record' fields and change the merge type to Directory. The attached is your original with the fieldnames changed and all rows except the first and the NEXT field removed. As a directory it too merges as intended.

Attached Files

50-50 Raffle1 - Directory Merge.docx (107.6 KB, 12 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com