Here I am showing one with example:
#!/bin/bash
export BASE=/home/oracle/gouranga
sendDt=`date +%m-%d-%Y`
sendMail_success()
{
mailx -a ${BASE}/sample01.csv -a ${BASE}/sample02.csv -a ${BASE}/sample03.csv -r no-replay@oracle.com -s "Sample files to download" mail1.test@oracle.com,mail2.test@oracle.com <<EOF
Hi Team,
Please find attached files for ${sendDt}.
--- File#1 contents
echo `cat ${BASE}/sample01.csv`
---File#2 contents
echo `cat ${BASE}/sample02.csv`
Thanks.
Regards,
DBA Team
EOF
}