OMG!!! Thanks to all! It actually works!
This is what works for me: I run a sql script that produces a tab delimited report showing tablespace usage (think of the OEM screen showing all the tablespaces with size, used and free listed). I then use the following command to send the report to me: uuencode filename outfile.xls | mailx -s "Dslb1osa Rpt_Tablespaces" tom@email_addr Even though the file is a text file, it still comes along as an attachment! really cool! thanks everyone! Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Thursday, February 13, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Mohammed, thanks, but the -m option does not seem to exist in Sun Unix. $ mailx -m mailx: illegal option -- m Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address -s SUBJECT -f FILE users any other ideas? Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Thursday, February 13, 2003 12:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] You mean: mailx -m -s "Test Message" [EMAIL PROTECTED] << EOF `ux2dos /home/report/tbsp.lst | uuencode /home/report/tbsp.lst` This is from an HP-UX system hth mohammed --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > All, > > I'm trying to send an email attachment (Oracle > Tablespace Report) from a Sun > Unix box to myself when the batch job runs. > > Anybody been able to do this? I can send the text > of the file, but what I > really want to do is to send the file (it's an Excel > Spreadsheet). > > thanks in advance. > > Tom Mercadante > Oracle Certified Professional > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).