Everybody,
can you tell me how express about this; we have text data file as :
parameter1 Parameter2
AA 55
BB 77
. .
. .
. .
We want to draw table for this data as attached then send as body of Email (4 Replies)
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)
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)
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)
Hi All,
i have a folder "fold" which will mostly have a date( like 1/2/2013 -a single date alone .whenever the date changes i shoud get a mail. could someone help me with this. (4 Replies)
hi all,
I want to Represent the data in table format in mail content
sample data should be like this...but i m trying to send this table to mail using unix command...hw do i do????even i echoed the table contents ...doesnt work.... help me
<table style="background-color:lightblue;">... (8 Replies)
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)
I have two details to send in html email, two details present in variables, Processname & date which I need to send html email in table. Column1 is Processname: Process1 & column 2 is date:16/6/16 4:55 AM
I have below basic html code, how to create table in html to send mail
echo "<html>" >>... (1 Reply)
I have two scripts, each script reads an individual data file and copies specific lines of data and sends to MySQL table. Only difference is, each script sends data to a separate column on the same DB. I want to use one script to populate DB table and have data look horizontal, with no overlapping.... (3 Replies)
Discussion started by: SysAdminRialto
3 Replies
LEARN ABOUT BSD
binmail
BINMAIL(1) General Commands Manual BINMAIL(1)NAME
binmail - send or receive mail among users
SYNOPSIS
/bin/mail [ + ] [ -i ] [ person ] ...
/bin/mail [ + ] [ -i ] -f file
DESCRIPTION
Note: This is the old version 7 UNIX system mail program. The default mail command is described in Mail(1), and its binary is in the
directory /usr/ucb.
mail with no argument prints a user's mail, message-by-message, in last-in, first-out order; the optional argument + displays the mail mes-
sages in first-in, first-out order. For each message, it reads a line from the standard input to direct disposition of the message.
newline
Go on to next message.
d Delete message and go on to the next.
p Print message again.
- Go back to previous message.
s [ file ] ...
Save the message in the named files (`mbox' default).
w [ file ] ...
Save the message, without a header, in the named files (`mbox' default).
m [ person ] ...
Mail the message to the named persons (yourself is default).
EOT (control-D)
Put unexamined mail back in the mailbox and stop.
q Same as EOT.
!command
Escape to the Shell to do command.
* Print a command summary.
An interrupt normally terminates the mail command; the mail file is unchanged. The optional argument -i tells mail to continue after
interrupts.
When persons are named, mail takes the standard input up to an end-of-file (or a line with just `.') and adds it to each person's `mail'
file. The message is preceded by the sender's name and a postmark. Lines that look like postmarks are prepended with `>'. A person is
usually a user name recognized by login(1). To denote a recipient on a remote system, prefix person by the system name and exclamation
mark (see uucp(1C)).
The -f option causes the named file, for example, `mbox', to be printed as if it were the mail file.
When a user logs in he is informed of the presence of mail.
FILES
/etc/passwd to identify sender and locate persons
/usr/spool/mail/* incoming mail for user *
mbox saved mail
/tmp/ma* temp file
/usr/spool/mail/*.lock lock for mail directory
dead.letter unmailable text
SEE ALSO Mail(1), write(1), uucp(1C), uux(1C), xsend(1), sendmail(8)BUGS
Race conditions sometimes result in a failure to remove a lock file.
Normally anybody can read your mail, unless it is sent by xsend(1). An installation can overcome this by making mail a set-user-id command
that owns the mail directory.
7th Edition April 29, 1985 BINMAIL(1)