Re: $$Excel-Macros$$ Macro to send Email various recipients

2012-01-11 Thread PrIyAnKa
Ok it's done On Wed, Jan 11, 2012 at 3:27 PM, NOORAIN ANSARI wrote: > Dear Priyanka, > > Try it and see attached sheet, hope it will help to you. > > Sub send_Email() > Dim olApp As Outlook.Application > Dim olMail As MailItem > Dim mailbody As String > For j = 2 To Sheet1.Cells(Rows.Count, "A").

Re: $$Excel-Macros$$ Macro to send Email various recipients

2012-01-11 Thread NOORAIN ANSARI
Dear Priyanka, Try it and see attached sheet, hope it will help to you. Sub send_Email() Dim olApp As Outlook.Application Dim olMail As MailItem Dim mailbody As String For j = 2 To Sheet1.Cells(Rows.Count, "A").End(xlUp).Row mailbody = "" & _ "Name " & _ "Amount " & _ "Count " & _ ""

Re: $$Excel-Macros$$ Macro to send Email various recipients

2012-01-10 Thread PrIyAnKa
Dear Mahesh I have tried for there but there was some problem for it Kindly help for something other On Tue, Jan 10, 2012 at 11:02 PM, Mahesh parab wrote: > Hi > > You can download sample workbook from below link. > > http://www.rondebruin.nl/sendmail.htm > > > HTH > Mahesh > > On Tue, Jan 10,

Re: $$Excel-Macros$$ Macro to send Email various recipients

2012-01-10 Thread Mahesh parab
Hi You can download sample workbook from below link. http://www.rondebruin.nl/sendmail.htm HTH Mahesh On Tue, Jan 10, 2012 at 6:14 PM, PrIyAnKa wrote: > Dear Team > > I need a macro which send mail from excel to the mentioned id in Excel > with data > > E.g. : from A to D data in excel is li