Shell Programming and Scripting

hhaha vgersh99!! its funny how the small things always get you in the end.

I may have overlooked, but I could not find any examples in the other forums as to how to email the value of a variable created in a Korn shell via mailx to a specific email account. In my case, I want to email the values of RecCount and RecCount2.

I'm assuming I would start by having something like this:

mailx -s "Results of SQL Query" myemail@blahblah.com > $RecCount $RecCount2

Could someone help me tweak this line or point me to a similar example? Thanks.

There 's a FAQ but you basically just need to get your redirections straight.

Code:

echo "$RecCount" "$RecCount2" | mailx -s "Results of SQL Query" myemail@example.com

If the text of the message needs to be more complex, use a "here document".

Code:

mailx -s "Result of SQL Query" myemail@example.com <<HERE
I thought you might like to know that RecCount is $RecCount and RecCount2 is $RecCount2

Take care, remember to be good
HERE

(Also, take care to not create new spam victim addresses in domains you do not own. example.com is good for use in examples; it's reserved by IANA for that purpose.)