|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 31st 07, 04:31 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
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 
|
| Ads |
|
#2
May 31st 07, 04:41 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 >
|
|
#3
May 31st 07, 04:48 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 > >
|
|
#4
May 31st 07, 10:37 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 >> > >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help me insert a table of data into a body of an email | funkymonkUK[_193_] | Excel Programming | 1 | June 26th 06 01:20 PM |
| Excel Email: Address and portion of body in cell | pete3589[_5_] | Excel Programming | 1 | November 11th 05 03:34 PM |
| body of email disappears when I send an email from Excel | ~A | Excel Discussion (Misc queries) | 0 | February 25th 05 10:55 PM |
| How to send filtered range in email body? | Benny[_2_] | Excel Programming | 2 | May 11th 04 07:56 AM |
| Copy and Paste a Worksheet Range to Email Body | Eric[_14_] | Excel Programming | 1 | January 20th 04 12:06 AM |
Linear Mode
