|
| 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. |
|
|||||||
| Tags: emailing, help, range, redemption, via, worksheet |
|
|
Thread Tools | Display Modes |
|
#1
July 17th 06, 04:04 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Help emailing worksheet range via Redemption
I am trying to automate an Excel macro so that it will run its update
and email the results without any user intervention. I have installed Redemption, and I can successfully send a test mail. The problem that I am having is that I cannot figure out how to send a worksheet, or a range from a worksheet. I can only send hard coded text. What do I need to put in the safeitem.body statement to send, say: Sheets("Sheet1").Range("A1:C10") Thanks! Tim 
|
| Ads |
|
#2
July 17th 06, 07:36 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help emailing worksheet range via Redemption
Save the worksheet as a file, then attach it to the message using
Attachments.Add. Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool wrote in message ups.com... I am trying to automate an Excel macro so that it will run its update and email the results without any user intervention. I have installed Redemption, and I can successfully send a test mail. The problem that I am having is that I cannot figure out how to send a worksheet, or a range from a worksheet. I can only send hard coded text. What do I need to put in the safeitem.body statement to send, say: Sheets("Sheet1").Range("A1:C10") Thanks! Tim
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| i can't get outlook to import info from the worksheet it created | oaksie1 | Outlook - General Queries | 5 | July 20th 06 06:13 PM |
| How to exclude meetings outside of range of hours from printout? | Caroline 8888 | Outlook - Calandaring | 0 | June 7th 06 01:39 PM |
| Hyperlinking from Outlook 2003 to an excel Worksheet | fidgitthedigit | Outlook - General Queries | 2 | May 5th 06 05:32 PM |
| Base OL recurrence range on a formula | Pharphel | Outlook - Calandaring | 4 | April 25th 06 02:30 PM |
| Calendar Date Range | Yoav | Outlook - Calandaring | 0 | March 24th 06 12:33 PM |
Linear Mode
