View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce[_2_] Bruce[_2_] is offline
external usenet poster
 
Posts: 25
Default 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