Automatic Email - with attachment excel
below is the Query i use to get Automatic mail from unix
uuencode SAC_Tire.zip SAC_Tire.zip > UCD_SAC_Tire.zip
cat body-message.txt UCD_SAC_Tire.zip > combined.txt
mailx -s "New Tire Transaction Report" -r "Automotive " `cat mailpcp1.dat` < combined.txt
my query is - in the Attached Excel- i have only one tab with all records of the report, now to that i have to add one more tab to that excel which contains Query to generate the report..