Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Mailx, Table, Multiple Email script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Mailx, Table, Multiple Email script
# 1  
Old 04-01-2014
Mailx, Table, Multiple Email script
Hello,

I am able to write some simple scripts in linux but this time it seems a little bit hard for me.

Objective: Script will read Database.txt file and will submit separate emails to multiple persons.

Database.txt
Code:
Elvis-Presley user_ssh1 ##20140403 firstperson@gmail.com
Julia-Roberts user_ssh2 ##20140403 secondperson@gmail.com
J-Lopez user_ssh3 ##20140403 thirdperson@gmail.com

In above database.txt file, you see the name of each user_ssh* account owner.
I need to send them seperate emails.

For example:

First email to firstperson@gmail.com:
Code:
Hello Elvis-Presley,
Your ssh account user_ssh1 will be expired on 2014.04.03

Fyi
Baris35,

Second email to secondperson@gmail.com:
Code:
Hello Julia-Roberts,
Your ssh account user_ssh2 will be expired on 2014.04.03

Fyi
Baris35,

Third email to thirdperson@gmail.com:
Code:
Hello J-Lopez,
Your ssh account user_ssh3 will be expired on 2014.04.03

Fyi
Baris35,

Thanks in advance
Boris
Last edited by Corona688; 04-02-2014 at 12:25 PM..
# 2  
Old 04-01-2014
Here's something to start with:

Code:
while read -r COL1 COL2 COL3 COL4
do
        echo "Col1 is $COL1, col2 is $COL2, col3 is $COL3"
done < inputfile

This User Gave Thanks to Corona688 For This Post:
baris35
# 3  
Old 04-01-2014
The fielded line-record input suggests "while read a b c d do ... done', with some substringing to get the date bits (the ksh/bash flavor ${c#????????} works but needs temp variable and second cut for month). Once you have the date divided, it is just something like 'echo "..."|mailx -s ... $d'.
This User Gave Thanks to DGPickett For This Post:
baris35
# 4  
Old 04-02-2014
Thanks,
Sorted by means of your valuable support now..

Regards
Boris
This User Gave Thanks to baris35 For This Post:
Corona688
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell Script to read hive table and send email

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

2. Shell Programming and Scripting

Mailx command - send mail as table format

I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong. Intended Output in mail body: Col1 Col2 Col3 ------ ... (2 Replies)
Discussion started by: qwertyu
2 Replies

3. Shell Programming and Scripting

connecting to table to extract multiple rows into file from unix script

I need to extract the data from oracle table and written the below code. But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output. And if I run the shell script with simple sql... (7 Replies)
Discussion started by: giridhar276
7 Replies

4. Shell Programming and Scripting

mailx script to do multiple emails

I am looking for a script that I can use with mailx to do the following: 1. Grab usernames from a flat file (one at a time) 2. Attach a file to the email and mail out. Thanks. Cubefeed (3 Replies)
Discussion started by: CubeFeed
3 Replies

5. Shell Programming and Scripting

sending mail using Mailx with data from oracle table

Hi, i need to send emails to the mail ids i receive using the sql query . SELECT L.ALARM_DEF,L.CRITERIA,L.DISTANCE_METRE,L.EMAIL,L.LAC_ID,L.LAST_CHECK,L.RANGE, L.RESOURCE_MSISDN,LM.ADDRESS,LM.NAME FROM LANDMARK_ALARM_CONF l, LANDMARK lm WHERE L.LANDMARK_ID=LM.LANDMARK_ID AND... (0 Replies)
Discussion started by: aemunathan
0 Replies

6. Shell Programming and Scripting

How to read email using mailx in shell script or perl

Hello, I am new to mailx and perl and I need help. I need create a shell script to read the mails on the SUN server, then parse the subject line and message body of each email to extract particular data so that I can pass these data fields in as application parameters to invoke a java... (4 Replies)
Discussion started by: jliharper
4 Replies

7. Shell Programming and Scripting

how to prevent multiple email notifications from monitoring script

Hi everyone, I am in the process of trying to decide the correct way to solve a particular scripting/email issue I have and would appreciate any advice. We have a cronjob running every 10 mins to check disk size on the server and if this exceeds a certain percentage then it will email a... (2 Replies)
Discussion started by: si_linux
2 Replies

8. Shell Programming and Scripting

Using mailx to send email to multiple users.

Hi, I am using the mailx command to send email to multple users. The command works fine when i am sending mail to a single user but when i insert multiple email ids inside the quote it does not work. All the email ids are coming from a property file.Please have a lookt at the property file and... (4 Replies)
Discussion started by: priyaksingh
4 Replies

9. UNIX for Advanced & Expert Users

Unable to send eMail from a UNIX-Host ( using mailx ) to a Outlook-email-addres(Win)

Hi A) I am able to send eMail using mailx from a UNIX ( solaris 8 ) host to my Outlook-email-ID : FName.Surname@Citigroup.com ( This is NOT my actual -eMail-ID). But in Outlook the "From :" eMail address is displayed as " usr1@unix-host1.unregistered.email.citicorp.com " .i.e the words... (2 Replies)
Discussion started by: Vetrivela
2 Replies

10. UNIX for Dummies Questions & Answers

sending email from mailx

hi can i know how to use mailx to send email to my lotus email account? i wan to send a file in a directory as an attachment and then email to lotus. can show me the command line to do it? thanks a lot (1 Reply)
Discussion started by: legato
1 Replies
Login or Register to Ask a Question