HI,
I have two scripts which is sending the mail in html format.
Script 1:
1.IFILE=/home/home01/Report.csv
if [ -r $IFILE ] #Checks if file exists and readable
then
if awk -F, '{ T += $13 } END { exit(!T) }' ${IFILE}
then
awk -F, 'BEGIN{
c=split("3,4,8,9,13", col)
print "To: abc@gmail.com"
print "Subject:REPORT"
print "MIME-Version: 1.0"
print "Content-Type: text/html"
print "Content-Disposition: inline\n"
print "<HTML><TABLE border=1>"
print "<TH>Code1</TH><TH>Bus</TH><TH>File1</TH>"
print "<TH>Code2</TH><TH>#tra</TH><TH>"
}
NR>4 {
printf "<TR>"
for(i=1;i<=c;i++) printf "<TD>%s</TD>", $col
print "</TR>"
}
END{
print "</TABLE></BODY></HTML>"
} ' ${IFILE} | sendmail -t
Script2:
IFILE=/home/home01/Report2.csv
if [ -r $IFILE ]; #Checks if file exists and readable
then
if awk -F, '{ T += $6 + $7 } END { exit(!T) }' ${IFILE}
then
awk -F, '
BEGIN{
c=split("1,2,3,4,5,6,7", col)
print "To: abc@gmail.com"
print "Subject: REPORT2"
print "MIME-Version: 1.0"
print "Content-Type: text/html"
print "Content-Disposition: inline\n"
print "<HTML><TABLE border=1>"
print "<TH>Orhaned Rule</TH><TH>File Entiity1</TH><TH>Entity 1 record Count</TH>"
print "<TH>File 2</TH><TH>Entity2</TH>"
print "<TH>Total</TH><TH>rejection</TH><TH>"
}
NR>4 {
printf "<TR>"
for(i=1;i<=c;i++) printf "<TD>%s</TD>", $col
print "</TR>"
}
END{
print "</TABLE></BODY></HTML>"
} ' ${IFILE} | sendmail -t
fi
fi
Now if i am running the two scripts separately i am getting two output as required.
Is there any way to send the output of both the scripts in one mail.
I tried calling both the scripts from one main script final_script.sh where i tried to send the output of both he scripts to one flat file and then cat file and sending the mail..But it is not working and in output actual html code is getting printed.
I tried below:
log=/home/home01
rndt=`date +"%m%d%y%H%M%S"`
OFILE1="${log}/${rndt}.log"
/home/home01/1.sh >> ${OFILE1}
/home/home01/2.sh >> ${OFILE1}
cat $OFILE1 | sendmail -t abc@gmail.com
Output coming something like this:
<TR><TD>* * * * * End Of Report * * * * *</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>
</TABLE></BODY></HTML>
Before running above code i remove the
sendmail -t
command from each individual script.
Pls help.