Re: Script to append values into excel sheet, zip and send mail

[FreeBeerReekingMonk]

Email will only work if your userid is allowed to send email.

There are 2 commands in Linux that can send email: mailx and sendmail

you would need to test them from the commandline first. If you manage to send email, these will work.

There is also a module that does what sendmail does, and only requires that your mailserver accepts incoming mail requests from you... which is sometimes tricky: Mail::Sendmail

[FreeBeerReekingMonk]

you can do an email.sh <myfile.ext> :

ATTACHMENT=$1
FNATT=`basename "$ATTACHMENT"`
EMAIL=[e-mail]
HOSTNAME=`hostname`
uuencode "$FNATT" "$ATTACHMENT" | mailx -s "$HOSTNAME $FNATT" $EMAIL

This is a fairly complete one (I really need to finish it):

fbrm@monastery:~/CODE/PERL/$ cat perl-mon/local/bin/emailto.sh
EMAILTO=$1
SUBJECT=$2
MSG=$3
FILE=${4:-""}

if [ -z "$EMAILTO" ] || [ -z "$SUBJECT" ] || [ -z "$MSG" ];then
        echo "$0 bad params."
        exit -1;
fi

#echo "EMAILTO=$EMAILTO"
#echo "SUBJECT=$SUBJECT"
#echo "MSG=$MSG"

MAILX=""
if [ -x "/usr/bin/mailx" ];then
        MAILX="/usr/bin/mailx"
elif [ -x "/usr/bin/mail" ];then
        MAILX="/usr/bin/mail"
fi

if [ ! -z "$MAILX" ];then
        if [  -z "$FILE" ];then
                #echo "$MSG  $MAILX -s $SUBJECT $EMAILTO"
                echo "$MSG" | $MAILX -s "$SUBJECT" "$EMAILTO"
        else
                FN=`basename "$FILE"`
                $(echo "$MSG\n" ; uuencode "$FILE" "$FN") | mailx -s "
+$SUBJECT" "$EMAILTO"
        fi
elif [ -x "/usr/bin/sendmail" ];then
        HOSTNAME=`hostname`
        if [ "$FILE" == "" ];then
                (
                  echo To: "$EMAILTO"
                  echo From: perlmon@$HOSTNAME
                #  echo "Content-Type: text/html; "
                  echo Subject: "$SUBJECT"
                  echo
                  echo "$MSG\n"
                #  cat tmp.html
                ) | sendmail -t
        else
                (
                  echo To: "$EMAILTO"
                  echo From: perlmon@$HOSTNAME
                #  echo "Content-Type: text/html; "
                  echo Subject: "$SUBJECT"
                  echo
                  echo "$MSG\n"
                  cat "$FILE"
                ) | sendmail -t
        fi
fi