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