Tag Archives: SUBJECT

Mailx recipient from mysql database

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

…read more

Source: FULL ARTICLE at The UNIX and Linux Forums