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



Comments

Post a Comment

Popular posts from this blog

WIMMount (HSM) causing cluster storage to go redirected (2012r2 DC)

-
looking options resolve error , prevent in future. thanks help. hardware: 2 node dell hv cluster running2012r2 dc 8 nic/ea in multiplex mode 4x hyper-v 4x hosts storage: 2x synology nas, accessed through iscsi hosts , cluster relevant logs: log name:      microsoft-windows-failoverclustering/diagnostic source:        microsoft-windows-failoverclustering date:          event id:      2050 task category: none level:         warning keywords:       user:          system computer:      l description: [dcm] filter wimmount found @ unsafe altitude 180700 log name:      system source:        microsoft-windows-failoverclustering date:         event id:      5125 task category: cluster shared volume level:         warning keywords:       user:          system computer: description: cluster shared volume 'volume1' ('cluster disk 1') has identified 1 or more active filter drivers on device stack interfere csv operatio
Read more

Failed to delete the test record dcdiag-test-record in zone test.com

-
ps c:\users\administrator.test> dcdiag /test:dns directory server diagnosis performing initial setup:    trying find home server...    home server = dc02    * identified ad forest.    done gathering initial info. doing initial required tests    testing server: default-first-site-name\dc02       starting test: connectivity          ......................... dc02 passed test connectivity doing primary tests    testing server: default-first-site-name\dc02       starting test: dns          dns tests running , not hung. please wait few minutes...          ......................... dc02 passed test dns    running partition tests on : forestdnszones    running partition tests on : domaindnszones    running partition tests on : schema    running partition tests on : configuration    running partition tests on : test    running enterprise tests on : test.com       starting test: dns          test results domain
Read more

Azure MFA with Azure AD and RDS

-
i have setup following lab in azure , need help. a server (domain controller) , remote desktop services. and server multi factor authentication server. i have setup following one http://www.rdsgurus.com/uncategorized/step-by-step-using-windows-server-2012-r2-rd-gateway-with-azure-multifactor-authentication/ and when im connecting got following error. the user "domain\username", on client computer "xxx.xxx.xxx.xxx", did not meet connection authorization policy requirements , therefore not authorized access rd gateway server. authentication method used was: "ntlm" , connection protocol used: "rpc-http". following error occurred: "23003". also on security log i've got following authentication details: connection request policy name: ts gateway authorization policy network policy name: - authentication provider: radius proxy authentication server: test.test.local authentication type: - eap t
Read more