how do you email a portion of a worksheet (range) as an insert into the body of an email?
 

I want to create a macro or a procedure that will take a portion of a
worksheet and then send it to an email address.
This is to basically sending an invoice. I want to include this in the BODY
and NOT as an attachment.

Thanks
Bruce

how do you email a portion of a worksheet (range) as an insert into the body of an email?
 

try ron's site
http://www.rondebruin.nl/sendmail.htm

--


Gary


"Bruce" wrote in message
...
I want to create a macro or a procedure that will take a portion of a worksheet
and then send it to an email address.
This is to basically sending an invoice. I want to include this in the BODY
and NOT as an attachment.

Thanks
Bruce

how do you email a portion of a worksheet (range) as an insert int
 

This site should help.

http://www.rondebruin.nl/sendmail.htm

"Bruce" wrote:

I want to create a macro or a procedure that will take a portion of a
worksheet and then send it to an email address.
This is to basically sending an invoice. I want to include this in the BODY
and NOT as an attachment.

Thanks
Bruce

how do you email a portion of a worksheet (range) as an insert into the body of an email?
 

Do you know how to set it up so taht it uses a specific account?
I have tried modifying to be like:
With OutMail
.To = emailname
.CC = ""
.BCC = bbcname 'bbc is set to a valid email address
.SendUsingAccount = bbcname
.Subject = "Invoice for - " & Range("L6").Value & " - " &
Application.Text(Range("L4").Value, "mmm-dd-yyyy")
.HTMLBody = RangetoHTML(rng)
.Send 'or use .Display

End With

Thanks




"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
try ron's site
http://www.rondebruin.nl/sendmail.htm

--


Gary


"Bruce" wrote in message
...
I want to create a macro or a procedure that will take a portion of a
worksheet and then send it to an email address.
This is to basically sending an invoice. I want to include this in the
BODY and NOT as an attachment.

Thanks
Bruce