Posted 02 February 2012 - 04:41 PM
I am attempting to design a mail merge using word and excel (Microsoft Office 2010)to be used in a silent auction for a non-profit benefit party. I want to set up a system that makes consolidating all the data on purchases and buyers, and generating receipts, fast and easy once the auction closes.
My problem is how to create a receipt through mail merge when each attendee (or buyer) purchases a different number of items (some 1, some 2, some none, etc.). At the end of the auction, the data input person will have an excel sheet that includes 4 columns: the purchased product's item number in column A, and its description in column b. To be filled in at the auction close is the buyer's ID number in column c, and the price in column d. At completion, a simple sort by buyer number will line up all the buyers and their purchases together. My question is - how do I create a mail merge form (to be the sales receipt) for each buyer that will list all of their purchases (one or several) and the total amount owed.
Maybe there is another way to think this through. However, I want to start with the item number in column A to make it quick and easy for the data person.
Thanks so much for your help!