Home
Man
Search
Today's Posts
Register

This forum is closed for new posts. Please post beginner questions to learn unix and learn linux in the UNIX for Beginners Questions & Answers forum.

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

Tags
beginners, mailx

 

 
Thread Tools Search this Thread
# 1  
Old 03-30-2010
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 .
Code:
cat Employee.sql 
 
SET VERIFY OFF
SET PAGESIZE 200

SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<TITLE>count of employeet</TITLE> -
"<STYLE type='text/css'> -
<!-- BODY {background: #FFFFC6} --> -
</STYLE>" -
BODY "TEXT='#FF00Ff'"-
TABLE "WIDTH='90%' BORDER='5' COLOR='#ffffff'"
SET MARKUP HTML ON ENTMAP ON
PROMPT <H> employee No </H>
PROMPT <H1> emp </H1>

spool Employee.html
SET MARKUP HTML ON ENTMAP OFF
PROMPT <H1> Report1  </H1>
SET MARKUP HTML ON ENTMAP ON
SET MARKUP HTML ON ENTMAP OFF
PROMPT <H> <B> Report2 </B>  </H>
SET MARKUP HTML ON ENTMAP ON
select count(*) from emp ;
SET MARKUP HTML ON ENTMAP OFF
PROMPT <P> </P>
spool off

exit


Then in another file1.sh on running this
Code:
#!/usr/bin/ksh
export MAIL_LIST='someone@gmail.com'

cd /home/bin
rm Employee.html
sqlplus username/passwordL@host @Employee.sql
(cat uuencode Employee.html )| mailx -s "Report" -m $MAIL_LIST

on running this html attachment is sended.
Biut i dont need the html atatchment , i need simailar tabular form it shouldcom eon the mail notes directly instead of one opening the attcahment .

please suggest.

Last edited by pludi; 03-30-2010 at 04:39 AM.. Reason: code tags, please...
 

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Send Mail With Attachment vamshi929 Shell Programming and Scripting 1 07-20-2018 10:25 PM
HTML mail with Attachment sudvishw Shell Programming and Scripting 1 08-20-2015 06:28 PM
Need help in sending html mail with attachment karthik adiga Shell Programming and Scripting 2 01-27-2015 10:52 AM
Send mail as attachment Amit786 Shell Programming and Scripting 4 12-19-2013 10:11 AM
Send mail using attachment unankix Shell Programming and Scripting 3 06-27-2012 11:21 AM
Unable to send mail with inline html along with attachment. Please help! thulasidharan2k Shell Programming and Scripting 1 05-27-2011 09:19 AM
How to send a mail with attachment? albaalbetti Shell Programming and Scripting 4 11-19-2009 11:59 AM
Unknown Attachment received on html mail pgop UNIX for Advanced & Expert Users 1 09-24-2009 06:19 AM
how to send file as attachment using mail or mailx kieranfoley UNIX for Advanced & Expert Users 1 05-21-2009 08:45 AM
Reading Delimited file and send mail with attachment acheiver Shell Programming and Scripting 3 02-28-2009 02:45 PM
how to send file as attachment with mail ? alert_every1 UNIX for Advanced & Expert Users 2 08-17-2008 03:10 AM
Sending HTML attachment through mail sushovan Shell Programming and Scripting 2 07-15-2008 09:47 AM
Command line/Script to send E-mail with HTML body and binary attachment G-Man AIX 3 04-18-2007 10:30 PM
AIX send mail with HTML message body and a binary attachment G-Man UNIX for Dummies Questions & Answers 4 03-22-2007 03:15 PM
Send an attachment and html text both in the same mail stefan.yu Shell Programming and Scripting 4 10-26-2006 10:46 PM


All times are GMT -4. The time now is 09:15 PM.

Unix & Linux Forums Content Copyright 1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password