Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Sheet as part of macro
The final barrier I'm running into in my quest for
automation of my reports is emailing them properly. Currently I email my reports within Excel, using the "Send this sheet as part of the body of the email" option. I'm wondering if this operation can be performed within a macro. Right now I'm using the "ActiveWorkbook.SendMail Recipients:=" command in vb, but this sends the mail as an attachment. I could edit my macro to trim the file down to the nessary data, but I'd rather continue to send the report the way I always have been. Any help is appreciated. Thanks tons for all the help. Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Sheet as part of macro
Joe,
See Ron's site at www.rondebruin.nl/sendmail.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Joe S." wrote in message ... The final barrier I'm running into in my quest for automation of my reports is emailing them properly. Currently I email my reports within Excel, using the "Send this sheet as part of the body of the email" option. I'm wondering if this operation can be performed within a macro. Right now I'm using the "ActiveWorkbook.SendMail Recipients:=" command in vb, but this sends the mail as an attachment. I could edit my macro to trim the file down to the nessary data, but I'd rather continue to send the report the way I always have been. Any help is appreciated. Thanks tons for all the help. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send Email With Cell Conent as Part of the Subject | Excel Discussion (Misc queries) | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Using a Macro in Excel to send an embedded sheet via Outlook | Excel Discussion (Misc queries) | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
Removing macro buttons from part of a sheet | Excel Programming |