There is a sheet with name "Sheet1" and it contains the following data: A1 contains name, B1 Product, C1 Amount, D1 Email A1 B1 C1 D1
Name Product Amount Email Raj Shoes 1000 a...@a.com Sun Socks 800 b...@b.com Raj Socks 700 a...@a.com Sun Ball 500 b...@b.com Raj Tennis 3000 a...@a.com Now a macro should be created in such a way that email should be send automatically to both "Raj" & "Sun" with details shown below Raj EMAIL DETAILS Name Product Amount Raj Shoes 1000 Raj Socks 700 Raj Tennis 3000 Total 4700 Sun Email Details Name Product Amount Sun Socks 800 Sun Ball 500 TOTAl 1300 Please keep in mind such a macro would be used to send emails to more than 1000 people. So please provide a error proof fully automatically macro. -- ---------------------------------------------------------------------------------- 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