sending an attachment through email

Sgiri1 · #1 (**permalink**) 03-02-2009

As a part of requirement I need to send out mails with attachment from UNIX. I have to take query the Oracle DB and send the result of the query in an attachment through mail.

I use the following script for the same.

#!/bin/csh
#!/bin/bash
#!/bin/ksh
ATTFILE=/folder1/test.xls
cd /opt/oracle/lin-10.1.0.4/bin
sqlplus userid/pwd@DVMRM @/folder1/test.sql
uuencode $ATTFILE $ATTFILE | mailx -s "Attachment" aa@yy.com

But the uuencode command is not recognized and I get the following error:
uuencode: command not found

what should be done to do away with this?

RedDwarf · #2 (**permalink**) 04-21-2009

Suggest, that perhaps this is a path issue ...
try - 'which uuencode' - to find out where uuencode is located on your machine.
In my case returns - /usr/bin/uuencode
Then can change your line to (in my case) -

/usr/bin/uuencode $ATTFILE $ATTFILE | mailx -s "Attachment" aa@yy.com

or

ensure /usr/bin is in your $PATH.

Hope this helps.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Sending attachment to webmail using UNIX	supriya5980	UNIX for Dummies Questions & Answers	4	02-04-2009 04:00 AM
Sending HTML attachment through mail	sushovan	Shell Programming and Scripting	2	07-15-2008 08:47 AM
Sending email with text & attachment using mailx	haryadoon	Shell Programming and Scripting	3	07-27-2006 01:49 AM
Sending attachment thru a mail	Rohini Vijay	UNIX for Dummies Questions & Answers	1	05-12-2006 01:13 PM
Sending email w/ ftp log as attachment	idesaj	UNIX for Dummies Questions & Answers	2	07-19-2005 11:48 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by