07-03-2013
if you include the table output in td it will consider it in one column..
I consider you are extracting data from Oracle DB? IF yes please read below article
Generating HTML Reports from SQL*Plus
---------- Post updated at 03:59 PM ---------- Previous update was at 03:52 PM ----------
to add....
save below in a file say mail_body
From: TTS.OO.Monitoring.Operations
Subject: Error
X-Mailer: htmlmail 1.0
Mime-Version: 1.0
Content-Type: text/html; charset=US-ASCII
loginto sqlplus -s user/password
SET MARKUP HTML ON SPOOL ON
spool mail_body append
run the query
exit
cat mail_body|sendmail <to address>
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
How can I write a HTML file in Unix.
Once I do that, I want to send this file as a body of a mail, along with writing a subject for the mail I am sending through unix.
How can that be done? (0 Replies)
Discussion started by: diwa81
0 Replies
2. Shell Programming and Scripting
I have automated some checks - and I want to send a email when there is an issue.
This is fine and I can send the email.
However - I want to generate the email in html format so I can highlight any issues to a reader..
ie. If there is a disk space issue - then the email will highlight the... (2 Replies)
Discussion started by: frustrated1
2 Replies
3. Shell Programming and Scripting
hi guys,
am required to prepare a report and mail it, to make it more appealing :p i wish to have content of mail in rich text format i.e html type
with mailx how to specify the content type of mail body as html?
Thanks in advance!!!
rishi (2 Replies)
Discussion started by: RishiPahuja
2 Replies
4. UNIX for Dummies Questions & Answers
hi,
I am new to unix.
I need send html content as a mail from my sun-solaris2.6 work station. When I tried that the recipient gets it as html code with all the tags.
any solutions?
thanx in advance (2 Replies)
Discussion started by: gmchoudary
2 Replies
5. UNIX for Advanced & Expert Users
Hi,
i've build a script, 1: neon_script and the other 2:neon_mailing those to scripts i run with 3:neon_handmatig
After that i get a mail in plain text in my mail box and i want it in html format. I already tried already a several things but nothings seems to work.
Somebody got i idea how... (3 Replies)
Discussion started by: Rensen
3 Replies
6. 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
7. Shell Programming and Scripting
Hi,
Can anyone tell me how to mail a html file in unix?
I have a HTML file which contains a table structure, and i want this table to be created in the mail body and mail it.
Does anyone have any suggestions. (3 Replies)
Discussion started by: rocky88
3 Replies
8. Shell Programming and Scripting
Hi Guys,
I was searching and landed up something here only.
This is the code and I want the formatted html in email but that is not working, anybody knows the reason why?
#!/bin/sh
set -x
DATE=`date -u`
# Print beginning of webpage
function html_header
{
cat <<END
... (5 Replies)
Discussion started by: bluemind2005
5 Replies
9. Shell Programming and Scripting
Hi,
I am using the below code:
#!/bin/ksh
SUBJ="Send mail from Unix with file attachments"
TO=sudha.viswanathan@jpmorgan.com
CC=sudha.viswanathan@jpmorgan.com
(
cat << !
To : ${TO}
Subject : ${SUBJ}
Cc : ${CC}
!
cat << !
MIME-Version: 1.0
Content-Type: text/html
`cat... (1 Reply)
Discussion started by: sudvishw
1 Replies
10. UNIX for Beginners Questions & Answers
I am receiving the below output in text format. The output is converted to HTML table using the code mentioned below
output in text
LogDate DayOfWeek/Hours _0_ _1_ _2_ _3_ _4_ _5_ _6_ _7_ _8_ _9_ _10_ _11_ _12_ _13_ _14_ _15_ _16_ ... (3 Replies)
Discussion started by: Dumpi16
3 Replies
JZIP(6) John's Z-code Interpreter Program JZIP(6)
NAME
jzip - execute Infocom v1-5 and Inform v1-5 & v8 game files
SYNOPSIS
jzip [ options ] z-file-name
DESCRIPTION
jzip invokes the Z-code Interpreter.
REQUIREMENTS
jzip will run under most (if not all) flavors of Unix, including AIX, Solaris, SunOS, HP/UX, Linux, Free/NetBSD, IRIX, NeXT Mach, DEC
OSF/1, and others.
EDITING
JZip now supports arrowkey editing in UNIX.
Up/Down
selects the previous / next command in history
Left/Right
moves the cursor over the line.
Backspace
deletes
Typing inserts under the cursor
OPTIONS
-l n lines in display
-c n columns in display
-r n text right margin (default = 1)
-t n text top margin (default = 0)
-v display version information
-m monochrome mode
-y set Tandy bit
-s n zmachine strict level, from 0 (none), 1 (report once, recommended) to 3.
ENVIRONMENT
jzip looks for the environment variable INFOCOM_PATH and will use the path found there to look for the story file specified on the command
line if the story file cannot be found in the current directory.
CREDITS
jzip is written and maintained by John Holder (j-holder@home.com), based on the ZIP v2.0 sources by Mark Howell and Olaf 'Olsen' Barthel.
AVAILABILITY
The most recent version of jzip can be downloaded from one of:
http://www.jzip.sourceforge.net/
ftp://ifarchive.org/infocom/interpreters/zip/
FILES
/usr/games/jzip
The Z-Code Interpreter Program
/usr/lib/games/zfiles
Recommended location for Zcode files
RELATED USENET NEWSGROUPS
Interactive Fiction (IF) authors should check out rec.arts.int-fiction, and IF players should check out rec.games.int-fiction.
2.1 JZIP(6)