Hi, Pls. refer the url mentioned below l for sending mails through outlook. A security overide application for outlook is also available in the net which will help you in sending mail without manual intervention.
I have been successfuly using this for some time. http://www.dicks-clicks.com/excel/olSending.htm Modify your code according to your requirements. On Tue, Jun 28, 2011 at 9:19 PM, Rajat Kapoor <rajat.bi...@gmail.com> wrote: > 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 > -- Regards Vasant skype Id: vasantjob vasant...@gmail.com -- ---------------------------------------------------------------------------------- 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
