By jazzyzha
Dear All,
Can I make Mailx to read recipient address from a mysql database?
I already tried emailing with bash script:
SUBJECT=”TEST”
export EMAIL_ADDRESS=`mysql -uroot -pabcde email -e “SELECT email FROM recipient”`
mysql -uroot -pabcde email -e “SELECT ID, SenderName, Body FROM inbox” | mailx -s “$SUBJECT” -a From:sales@acme.com “$EMAIL_ADDRESS”
but no luck. Any help would be very appriciated. Thanks