@googlegroups.com
*Date: *Wed, 28 Nov 2012 20:12:36 +
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Modify Code to to send range *
Thanks, Ashish for you time. i however get a debug error with this code
Sub send_emails(to1 As String
Thanks, Ashish for you time. i however get a debug error with this code
Sub send_emails(to1 As String, fld1 As String, body1 As String)
Dim olApp As Outlook.Application
thanks
On Tue, Nov 27, 2012 at 3:24 PM, ashish koul koul.ash...@gmail.com wrote:
Sub emailstest()
' run loop here
Subject: Re: $$Excel-Macros$$ Modify Code to to send range *
Thanks, Ashish for you time. i however get a debug error with this code
Sub send_emails(to1 As String, fld1 As String, body1 As String)
Dim olApp As Outlook.Application
thanks
On Tue, Nov 27, 2012 at 3:24 PM, ashish koul koul.ash
Sub emailstest()
' run loop here
Dim bdy As String
Dim bdyrng As Range
Dim cl As Range
Set bdyrng = Sheets(1).Range(g2:g50)
For Each cl In bdyrng
bdy = bdy vbNewLine cl.Text
Next
' run loop here
Call send_emails(Range(b2).Text, Range(c2).Text, bdy)
End Sub
Sub send_emails(to1 As
Hello Excel Gurus,
in the attached file i have a vba code that sends email with attachments,
what i need is a little code addition to the code to include adding any
comments in the range eg G2:G30 to the code, so that anytime i include
something in that range, it will be part of the email ,