08-31-2013
How to send mails based on email ids residing in table?
Hello Gurus,
I have one table which consists of two field:-
PROG_NAME EMAIL
xxxx email1,email2,email3
yyyy email4,email1,email2
I want to to send mails by using mailx command.
But how do I get each and every mail ids from table against each prog_name
I have used sql query and stored the email field values at text file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i am trying to send mail with attachment to web-based email client like gmail.com using mailx. the problem is it is displayed in content rather than as attachment.
the code i am using is as follows,
uuencode test1.txt test1.txt | mailx -s "test only" aaaa@gmail.com
does anyone... (1 Reply)
Discussion started by: randomcz1
1 Replies
2. UNIX for Dummies Questions & Answers
Hi
Can any one help me out ?
I am trying to send an autogenerated mail with an attachment to bulk of users using 'MAILX' and 'UNENCODE' . I have used it as follows
X " ( cat /sastemp/body.txt; uuencode Test.xls.gz Test.xls.gz ) | mailx -s 'Testing' ' abcd@yahoo.com , efgh@gmail.com ' "
... (9 Replies)
Discussion started by: manas6
9 Replies
3. Shell Programming and Scripting
hi,
I want to send mail to DL...
i am sending email to single id using mailx .. how to send to group of ids? :confused:
i am using a file which conatins all the ids,
is there any other way to send mail without creating the DLfile?
DL=path\file.txt
mailx -s "Info BG is now... (4 Replies)
Discussion started by: sreelu
4 Replies
4. Shell Programming and Scripting
Hi All
can someone help please create a bash script.
Here's a scenario:
1. I have a directory where it's a destination for scanned documents. e.g. /dest/scan
2. The filename is in the form IDNumber_Category. e.g. 123456_notes.pdf
3. The first part of the script is to rename the... (1 Reply)
Discussion started by: aemestech
1 Replies
5. Shell Programming and Scripting
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Discussion started by: nairshar
2 Replies
6. Shell Programming and Scripting
i have below code to count number of rows in file1.txt, if the row count is more than one then i have sending an email along with file1.txt attached and fail the process(do nothing if count is <=1),
if I test individually count part works good but when i include the email part its not working,... (1 Reply)
Discussion started by: srini_106
1 Replies
7. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
8. Shell Programming and Scripting
hi,
I added an email id to a list of existing aliases in .mailrc on my unix box, using vi editor. However, the new id has not been receiving any mails from the box.
Kindly help as to what needs to be done here. Does the box need to be rebooted for these changes to reflect? Is there any other... (5 Replies)
Discussion started by: qwerty000
5 Replies
9. Solaris
Hi how to send below prstat script output into table format and send through email?
prstat|awk '{ if ($9 >= 5) print $0 }' (17 Replies)
Discussion started by: tharmendran
17 Replies
10. UNIX for Beginners Questions & Answers
HI Team,
I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body.
below script:
#!/bin/bash
hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
LEARN ABOUT CENTOS
reporter-mailx
REPORTER-MAILX(1) LIBREPORT MANUAL REPORTER-MAILX(1)
NAME
reporter-mailx - Sends contents of a problem directory via email.
SYNOPSIS
reporter-mailx [-v] -d DIR [-c CONFFILE]
DESCRIPTION
The tool reads a problem directory, composes an email message from the directory contents, and uses mailx to send the message to specified
recipient.
Properties of email messages can be specified in a configuration file, and via environment variables.
Configuration file
Configuration file contains entries in a format "Option = Value".
The options are:
Subject
The subject of the email message.
EmailFrom
The sender of the email message.
EmailTo
The recipient of the email message.
SendBinaryData
Use yes/true/on/1 to attach all binary files from the problem directory to the email. This can cause the emails to be very large.
Integration with ABRT events
reporter-mailx can be used as a reporter, to allow users report problems via email when they decide to do it. This usage is pre-configured
in /etc/libreport/events.d/mailx_event.conf:
EVENT=report_Mailx reporter-mailx
It can also be used to notify administrator automatically when a problem happens. When this is desired, modify the event configuration file
to run the tool on the post-create event:
EVENT=post-create reporter-mailx
OPTIONS
-d DIR
Path to problem directory.
-c CONFFILE
Path to configuration file. When used in ABRT event system, the file contains site-wide configuration. Users can change the values via
environment variables.
ENVIRONMENT VARIABLES
Environment variables take precedence over values provided in the configuration file.
Mailx_Subject
Subject of the email message.
Mailx_EmailFrom
Sender of the email message.
Mailx_EmailTo
Recipient of the email message. If nor the environment variable nor the corresponding option is defined, the message is send to
"root@localhost".
Mailx_SendBinaryData
Use yes/true/on/1 to attach all binary files from the problem directory to the email.
AUTHORS
o ABRT team
LIBREPORT 2.1.11 06/18/2014 REPORTER-MAILX(1)