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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce - 31 May 2007 04:31 GMT

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

Reply to this Message

Gary Keramidas - 31 May 2007 04:41 GMT

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

Signature

Gary

>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.
[quoted text clipped - 3 lines]
> Thanks
> Bruce

Reply to this Message

Bruce - 31 May 2007 22:37 GMT

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

> try ron's site
> http://www.rondebruin.nl/sendmail.htm
[quoted text clipped - 6 lines]
>> Thanks
>> Bruce

Reply to this Message

JLGWhiz - 31 May 2007 04:48 GMT

This site should help.

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

> 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.
[quoted text clipped - 3 lines]
> Thanks
> Bruce

Reply to this Message