|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Mailx command - send mail as table format
Post 302737661 by qwertyu on Thursday 29th of November 2012 11:28:00 AM
11-29-2012
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
------ ------- ------
Bombay Raj 23
Delhi Raja 24
etc..
But what i get currently is :
Col1 Col2 Col3
---- ----- ------
Bombay Raj 23
Delhi Raja 24
etc..
Please suggest a way how i can format this in the mail body.
P.S: The file to which i re-direct the query output is formatted as required, but the mail body isnt. Please help. TIA!
---------- Post updated at 09:58 PM ---------- Previous update was at 09:56 PM ----------
Sorry the intended output has to have the right amount of spaces.
Somehow the spaces disappeared in the post. Please help. TIA!
Intended Output in mail body:
Col1 Col2 Col3
------ ------- ------
Bombay Raj 23
Delhi Raja 24
etc..
But what i get currently is :
Col1 Col2 Col3
---- ----- ------
Bombay Raj 23
Delhi Raja 24
etc..
Please suggest a way how i can format this in the mail body.
P.S: The file to which i re-direct the query output is formatted as required, but the mail body isnt. Please help. TIA!
---------- Post updated at 09:58 PM ---------- Previous update was at 09:56 PM ----------
Sorry the intended output has to have the right amount of spaces.
Somehow the spaces disappeared in the post. Please help. TIA!|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I use maix command to sent mails.
i can sent only plain text mails.
Unable to sent mails in html format.
while sending mails in html format, the received mail has the html code only. (17 Replies)
Discussion started by: p_prathaban
17 Replies
2. Shell Programming and Scripting
Hi all
I have a shell script that uses a stored proc to generate output from some tables and send the same in an e-mail using mailx command. Now I need to convert the output to excel format and send e-mail. How can I achieve this. Please help me in this regard, as it's very urgent and I have been... (5 Replies)
Discussion started by: sanbabu
5 Replies
3. Shell Programming and Scripting
Hi,
I am using mailx command to send a mail with attachment. It's working fine, but with attachment I am getting one extra attachment like (ATT00131.txt). I have tried to use unix2dos command also. But still I am getting the extra attachment.
I am using the following code:
subject="temp... (5 Replies)
Discussion started by: viswanatharv
5 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
Can you please help me in solving this. I am facing some problem sending mails.
If I use like this, I am able to send mail the mail
echo "This is an automated e-mail; please do not reply." | mailx -s "Good Morning ." 'abc@xys.com'
But if I use like this, then I am unable to send... (1 Reply)
Discussion started by: manas6
1 Replies
5. UNIX for Dummies Questions & Answers
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
Hi,
Our requirement is to send an attachment and content in a single mail. I am using the below command to send attachement.
---------------------
(uuencode $exp_file $exp_file) |mailx -s "$email_subject" $EmailRecipients
--------------------
I m not able to send any message in the... (4 Replies)
Discussion started by: ashwin3086
4 Replies
8. Solaris
Hi,
I am using solaris 5.9 OS and I am facing an issues with mailx.
My SMTP port is configured to listen 6190 and not the default one which is 25. I can send mail to my inbox when i do it manually through the following steps
root@<dbname> # telnet 15.12.88.10 6190
Trying 15.12.88.10...... (0 Replies)
Discussion started by: Srinathkiru
0 Replies
9. Shell Programming and Scripting
Hi All,
I am using mailx to send the mail. Due to some changes in the requirement, I need to send the mail to CC only (an Email id in CC), with no email ID in "TO" field. Can we do that? bcz I used -c flag only and got the message:":The flags you gave make no sense since you're not sending... (2 Replies)
Discussion started by: unankix
2 Replies
10. Shell Programming and Scripting
Hi All,
I am trying to send a mail from linux server but could'nt able to send the mail.
I tried the below syntax's so far but no luck.
mail -s “Hello world” abc@xyz.com < /usr/g/txt.log
cat "txt.log" | mailx -s "Hello world" abc@xyz.com
mailx -s “Hello world” abc@xyz.com <... (2 Replies)
Discussion started by: scriptscript
2 Replies
LEARN ABOUT MINIX
MAIL(1) General Commands Manual MAIL(1) NAME
mail - send and receive electronic mail SYNOPSIS
mail [-dpqrv] [-f file] [user] OPTIONS
-d Force use of the shell variable MAILER -f Use file instead of /usr/spool/mail/user as mailbox -p Print all mail and then exit -q Quit program if SIGINT received -r Reverse print order, i.e., print oldest first -v Verbose mode EXAMPLES
mail ast # Send a message to ast mail # Read your mail DESCRIPTION
Mail is an extremely simple electronic mail program. It can be used to send or receive email on a single MINIX system, in which case it functions as user agent and local delivery agent. If the flag MAILER is defined in mail.c, it can also call a transport agent to handle remote mail as well. No such agent is supplied with MINIX. When called by user with no arguments, it examines the mailbox /usr/spool/mail/user, prints one message (depending on the -r flag), and waits for one of the following commands: <newline> Go to the next message - Print the previous message !command Fork off a shell and execute command CTRL-D Update the mailbox and quit (same as q) d Delete the current message and go to the next one q Update the mailbox and quit (same as CTRL-D) p Print the current message again s [file] Save message in the named file x Exit without updating the mailbox To send mail, the program is called with the name of the recipient as an argument. The mail is sent, along with a postmark line containing the date. For local delivery, a file named after the recipient in the directory /usr/spool/mail must be writable. If the directory /usr/spool/mail does not exist then the mail is dumped on the console, so that system programs have a way to notify a user on a system that does not have a mail spool. MAIL(1)