Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-02-2016, 11:00 PM
Nightspear Nightspear is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Nov 2016
Posts: 2
Nightspear is on a distinguished road
Default mail merge raffle ticket numbering problem


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
Reply With Quote
  #2  
Old 11-03-2016, 01:17 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,227
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

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
File Type: docx Ticket Merge.docx (111.0 KB, 3 views)
File Type: xlsx 50-50 Raffle - Ticket numbers.xlsx (12.0 KB, 6 views)
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 11-03-2016, 04:02 AM
Nightspear Nightspear is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Nov 2016
Posts: 2
Nightspear is on a distinguished road
Default

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.

Last edited by Nightspear; 11-03-2016 at 04:16 AM. Reason: more information
Reply With Quote
  #4  
Old 11-03-2016, 05:11 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,227
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

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
File Type: docx 50-50 Raffle1 - Directory Merge.docx (107.6 KB, 2 views)
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Raffle ticket numbering Ulodesk Word 3 06-17-2014 02:31 PM
Mail Merge Auto Numbering MaxBuck Mail Merge 5 02-19-2013 08:13 PM
mail merge to raffle tickets merrittr Mail Merge 1 03-08-2012 10:41 PM
URGENT: Mail 'Merge To New Doc' restarts paragraph numbering at each Section break JamesF Word 0 07-28-2011 07:26 AM
problem in Mail merge rjagathe Mail Merge 0 08-12-2009 08:25 AM


All times are GMT -7. The time now is 10:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft