Suppose there are fields like: Name, Commision, Email Id etc in Sheet1 Now Data contained is given below Name Commission Email ABC 1000 a...@abc.com DEF 500 d...@abc.com ABC 700 a...@abc.com ABC 800 a...@abc.com DEF 500 d...@abc.com Now I can used either "Pivot Table" or "AutoSum" to get total of ABC & DEF. But I want a macro should be created according to which email should be send to ABC and DEF containing there data only along with Subtotal or Total. This is just a example. Record can be easily more than 1000 and it is not possible to send email manually. It should be send automatically to each receiptant .
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
