Mail Merge issue

hi:

i attempting design mail merge using word , excel used in silent auction non-profit benefit party.  i want set system makes consolidating data on purchases , buyers, , generating receipts,  fast , easy once auction closes. (i using office 2010).

my problem how create receipt through  mail merge when 1  person buys 1 item, buys 4 items, , third buys no items.   make easy data input person, use excel sheet includes item number in column a, it's description in column b, buyer number in column c, , price in column d.  at completion, simple sort buyer number line buyers , purchases together.  my question - how create mail merge form (the receipt) each buyer list of purchases (one or several) , total amount owed.  

maybe there way think through.  however, want start item number in column make quick , easy data person.   

thanks help!

hi katrina,

you can use word's catalogue/directory mailmerge facility (the terminology depends on word version). see how mailmerge data source supported word, check out microsoft word catalogue/directory mailmerge tutorial at:
http://lounge.windowssecrets.com/index.php?showtopic=731107
or
http://www.gmayor.com/zips/catalogue%20mailmerge.zip
tutorial covers list creation insertion & calculation of values in multi-record tables in letters. read tutorial before trying use mailmerge document included it.
 
recent, worked example, see attachment post #13 at: http://www.msofficeforums.com/mail-merge/9180-mail-merge-duplicate-names-but-different-dollar.html
 
alternatively, may want try many 1 utility on mergetools add-in can download following page of doug robbins' windows live skydrive: https://skydrive.live.com/?cid=5aedcb43615e886b#cid=5aedcb43615e886b&id=5aedcb43615e886b%21111

---

cheers
paul edstein
[ms mvp - word]

Microsoft Office  >  Word IT Pro Discussions