Send mail based on a group


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Send mail based on a group
# 1  
Old 12-10-2012
Tools Send mail based on a group

Hello Gurus,
I have a question.

I have a file which has 2 columns and is tab separated and looks like below:

FIELD1 FIELD2
Code:
Manual m456@hotmail.com
Execution din098@gmail.com 
Artistic m456@hotmail.com
Graphic din098@gmail.com

FIELD2 values will have always either of the 2 above mentioned email addresses.What i'm trying to do is sort the FIELD2 values according to the email addresses i.e. which would look like below.

FIELD1 FIELD2
Code:
Manual m456@hotmail.com
Artistic m456@hotmail.com
Execution din098@gmail.com
Graphic din098@gmail.com

Now i would like to send only 1 email to the email address 'm456@hotmail.com' saying that you have two values assigned to you namely (Manual and artistic) and i would even want to send only 1 email to 'din098@gmail.com' saying that you have two values assigned to you namely (Execution and Graphic).

Could anybody please help me achieve the above requirement ?
Any help is highly appreciated.

Last edited by Franklin52; 12-11-2012 at 05:21 AM.. Reason: Please use code tags for data and code samples
# 2  
Old 12-10-2012
Code:
awk 'NR>1 { print $2 | "sort | uniq" } ' input_file | while read mail_id
do
        awk ' BEGIN { print "Assigned Values: " } /'$mail_id'/ { print $1 } ' input_file | mailx -s "Group Info" ${mail_id}
done

This User Gave Thanks to Yoda For This Post:
# 3  
Old 12-10-2012
Code:
awk '{a[$NF]=a[$NF] FS $1}END{for (i in a) print "Assigned Values: " ,a[i] |mailx -s "Group info" i}' infile

This User Gave Thanks to rdcwayx For This Post:
# 4  
Old 12-11-2012
Thank you very much gurus bipinajith and rdcwayx, i really appreciate your quick help.Smilie
# 5  
Old 12-12-2012
Thanks very much.

Last edited by Max499; 01-24-2013 at 04:34 PM.. Reason: Please use code tags for data and code samples
# 6  
Old 01-24-2013
Missing First row-- Please help

Hi bipinajith,

Actually the code would miss the first line and it's reading from the second line.
For instance if i have only one row of data, then there's no email sent to anybody.
I've tried removing NR>1 but it still does the same.
Can somebody help me with it please.
# 7  
Old 01-24-2013
I put NR>1 to avoid the file header FIELD1 FIELD2

So removing NR>1 should work:
Code:
awk '{ print $2 | "sort | uniq" } ' input_file

Can you explain what exactly is the issue that you are facing?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Client was not authenticated to send anonymous mail during MAIL FROM (in reply to MAIL FROM comm

I am having trouble getting mail to work on a red hat server. At first I was getting this message. Diagnostic-Code: X-Postfix; delivery temporarily suspended: connect to :25: Connection refused Then added the port to my firewall. Then I temporarily turned off selinux. I then copied this file... (1 Reply)
Discussion started by: cokedude
1 Replies

2. UNIX for Beginners Questions & Answers

Manipulate condition to send mail based on output text in file

Hi All, I have a working script as below. echo "Files loaded with $(cat /var/tmp/script.X1.out)" | mail -s "Files loaded with return code" mailid This script takes the output from script.X1.out file and appends the text "Files loaded with return code" and sends the email. Now what I want... (5 Replies)
Discussion started by: midhun3108
5 Replies

3. UNIX for Beginners Questions & Answers

Read a file and send mail based on grep

Hi All, I am having a job and I need to send email when the job is running. On any other case (success,fail) I don't needed to send email. I check with BMC they told they dont have that in the version I am using. So I created a dependent job and grepped for the status and sent email. My... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies

4. Ubuntu

Not able to send mail out of UbuntuBox in send mail

Hi Guys.. yesterday i purchased a VPS server and installed sendmail on ubuntu 12.4 with Webmin & Apache runing webserver problem is.. i can send mail via webmin user interface account to anybody to out side to any domain and able to recieve any mail from any domain.. Now main... (2 Replies)
Discussion started by: cmdman
2 Replies

5. UNIX for Advanced & Expert Users

How can I send a mail from my outlook or other mail accounts to UNIX server?

Hi all, I want to send a mail for my business needs from outlook account to an unix server (HP-UX) but I don't send any mail. While I can send from the unix server to my outlook account, I can't send from outlook to unix. How can I achieve this ? How can I send a mail from my outlook or other... (2 Replies)
Discussion started by: igelegin
2 Replies

6. UNIX for Advanced & Expert Users

Group the records based on empno and send mail

Hi All, I have records in a file with name,SSO,openitems,manageremail with | delimited file.Now i want to group the records by SSO and openitems and send email to their manageremail. kiran|1111|draft|aaa@gmail.com guna|2222|reject|bbb@gmail.com kiran|1111|submitter|aaa@gmail.com... (2 Replies)
Discussion started by: kiranparsha
2 Replies

7. UNIX for Advanced & Expert Users

need to configure mail setting to send mail to outlook mail server

i have sun machines having solaris 9 & 10 OS . Now i need to send mail from the machines to my outlook account . I have the ip adress of OUTLOOK mail server. Now what are the setting i need to do in solaris machines so that i can use mailx or sendmail. actually i am trying to automate the high... (2 Replies)
Discussion started by: amitranjansahu
2 Replies

8. Shell Programming and Scripting

how to write a shellscript to send a mail alert to the website user based on license expiration time

hi, i am very much new to shell scripting i have a requirement that i have to develop a License Renewal Alert system that has to give a alert mail to the users before 30days of user account expiration, by checking expiration date of the user with the data base, this system will... (0 Replies)
Discussion started by: deepu_Shscripts
0 Replies

9. UNIX for Dummies Questions & Answers

How to send html file in a mail not as an attachment but it should display in the mail in table for

Hi The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment . cat Employee.sql SET VERIFY OFF SET PAGESIZE 200 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON - HEAD... (0 Replies)
Discussion started by: mani_isha
0 Replies

10. UNIX for Dummies Questions & Answers

can not send mail from unix server to company/yahoo mail

hi, Gurus, I need some help with sending mail out from my UNIX server: It is running Solaris 2.6 and the sendmail version is 8.8. Output of :/usr/lib/sendmail -d0.1 -bt < /dev/null Version 8.8.8+Sun Compiled with: LOG MATCHGECOS MIME7TO8 MIME8TO7 NAMED_BIND NDBM NETINET ... (5 Replies)
Discussion started by: b5fnpct
5 Replies
Login or Register to Ask a Question