omotey
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 28 Nov 2012 20:12:36 +
> *To: *
> *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 wi
Choose In tools ~reference ~ microsoft outlook
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Hilary Lomotey
Sender: excel-macros@googlegroups.com
Date: Wed, 28 Nov 2012 20:12:36
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Modify Code to
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 wrote:
> Sub emailstest()
>' run loop here
>
> Dim bdy As String
>
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
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 , tha
