Merge excel list into Word Receipt

I have an excel spreadsheet that I use for our annual charity auction. The excel spreadsheet has two sheets. One sheet for the guests with the their corresponding paddle numbers. The second sheet is the list of items for sale. I manually enter the paddle number, guest name, and final price next to the item for whoever wins it.

Is there a way to create a Word document template receipt and have a way to merge this second list into the the document? This would create a receipt for each customer that lists each of the winning item, as one guest could buy multiple items.

I appreciate a help that can be given. I attached a sample excel database (with the completed winning bids and corresponding winning guest) and a sample Word receipt template for anyone who is interested in assisting.

Hi

I don't know much about importing into Word,but you can generate a receipt directly in Excel.

I have added a sheet to your spreadsheet showing a receipt. You select the buyer paddle from a dropdown box, and the form auto fills with the information from the first two sheets.

No doubt there are other ways of accomplishing this, but this gives you something to think about and use if you wish.

One other thing - you can hide the N/A# by colouring errors white (under conditional formatting) so they can't be seen and won't print. I just left them visible so you can see what is going on.

I actually really like that, but my only issue is ease of printing. Basically these receipts need to be drawn up and printed within like 30 minutes for the auction taking place.

It would be time consuming to dropdown, pick the number, and print every receipt. That's why a mail merge with Word is nice, cause you run the merge and get all the receipts in one document. Print and all good. The issue with that is that it doesn't group purchases onto one receipt. So if someone buys 4 things, they have four receipts.

Any ideas?

I think this would be easy to automate using VBA, but this is outside my ability. Maybe someone else can write a quick macro that would cycle through each paddle number and print it out for you.

Completely understand. Big help though. Thank you