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 johnasmit...@gmail.comwrote:
I use a file with a macro (which this wonderful group collectively
contributed to)
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 koul.ash...@gmail.com wrote:
try this see if
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
I use a file with a macro (which this wonderful group collectively
contributed to) which when I highlight a range and hit ctrl + s it drops it
into a new excel file, opens outlook and addresses it to the addresses in
the macro.
I would like to let the user put an email address in a cell and when