use this one if you email adress for to is in cell b1
and email adress for cc is in cell c1
With OutMail
.to = ActiveSheet.Range("b1").Text
.CC = ActiveSheet.Range("c1").Text
and if you want to make it dynamic
Dim I as long
I= 1 '( choose row no)
With OutMail
Ashish,
Thank you for your quick response. I got it to work thank you. Could you
explain ("b" & I).Text please as it refers to a location? Thank you for
your excellent assistance learning Excel.
John
On Wed, Jan 26, 2011 at 7:40 AM, ashish koul wrote:
> try this see if it helps
>
>
> Wit
try this see if it helps
With OutMail
.to = ActiveSheet.Range("b" & I).Text
.CC = ActiveSheet.Range("c" & I).Text
On Wed, Jan 26, 2011 at 1:51 AM, John A. Smith wrote:
> I use a file with a macro (which this wonderful group collectively
> contributed to) which when I h
