Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to send html file in a mail not as an attachment but it should display in the mail in table for
Top Forums UNIX for Dummies Questions & Answers How to send html file in a mail not as an attachment but it should display in the mail in table for Post 302408596 by mani_isha on Tuesday 30th of March 2010 03:37:34 AM
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...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Send an attachment and html text both in the same mail

Hi all, I am working on UNIX (Solaris28). I would like to send an email in which the body will be in html format and, in the same mail, a xls file has to be attached. I have tried this: the file is correctly attached but the body comes as html source and not formatted. If I do not attach the... (4 Replies)
Discussion started by: stefan.yu
4 Replies

2. UNIX for Dummies Questions & Answers

AIX send mail with HTML message body and a binary attachment

I'm trying to script sending an e-mail message on an AIX 5.x server with the following requirements: 1. command line switch to specify file name containing message body in HTML format 2. command line switch to specify file name of a binary attachment 3. command line or input file to specify... (4 Replies)
Discussion started by: G-Man
4 Replies

3. AIX

Command line/Script to send E-mail with HTML body and binary attachment

I apoligize for the cross-post but I'm not getting much in the way of help in the dummies forum: I'm trying to script sending an e-mail message on an AIX 5.x server with the following requirements: 1. command line switch to specify file name containing message body in HTML format 2. command... (3 Replies)
Discussion started by: G-Man
3 Replies

4. Shell Programming and Scripting

Sending HTML attachment through mail

Hi I am new to unix and scripting.I am trying to send a html file as an attachment. SUBJECT="Type of Exceptions in Application" TO=Sushovan.Samals@gmail.com SPOOLFILE=/data/reg/tlogs/Monitor.html #echo "Send the E-mail message..." uuencode $SPOOLFILE $SPOOLFILE | mailx -s "$SUBJECT" $TO... (2 Replies)
Discussion started by: sushovan
2 Replies

5. UNIX for Advanced & Expert Users

how to send file as attachment with mail ?

hello , i m new to linux/unix , well in my college their is linux server to which we all (i and my frnds) login , we can send mail to each other through command "mail" . but any one can tell me how can i attached a binary file with mail. we are using red hat , "pine ", "mailx" , all... (2 Replies)
Discussion started by: alert_every1
2 Replies

6. Shell Programming and Scripting

Reading Delimited file and send mail with attachment

Hi All, My requirement is: 1. To read a file that contains log file location and server name. The format of the file is something like this : server_name1:logfilename1 server_name2:logfilename2 2. Now I wants to grep "error" string from the logfilename and put it into another file for... (3 Replies)
Discussion started by: acheiver
3 Replies

7. UNIX for Advanced & Expert Users

how to send file as attachment using mail or mailx

I have a need to send a file from the unix command line to be sent as an attachment. Is this possible? That is when I open my outlook email I need to file to appear as an attachment. Also, is there a way to use the mail binary (not mailx) to modify the "reply address". mailx -r works but I need... (1 Reply)
Discussion started by: kieranfoley
1 Replies

8. Shell Programming and Scripting

Unable to send mail with inline html along with attachment. Please help!

The below code is not working. I am able to send only inline html or only attachment. When trying to do both, only inline html is sent without attachment. Please help! #!/bin/ksh (echo "Subject: Test Mail - HTML Format" echo "MIME-Version: 1.0" echo "Content-Type: text/html" echo... (1 Reply)
Discussion started by: thulasidharan2k
1 Replies

9. Shell Programming and Scripting

Need help in sending html mail with attachment

Hi Everyone, I am facing problems in sending html mail with attachemnt. I will able to send mail with attachment (plain text ) using mailx -s and uuencode command and also html mail without attachment using sendmail option. However I am not able to send html mail along with attachment.Either... (2 Replies)
Discussion started by: karthik adiga
2 Replies

10. Shell Programming and Scripting

HTML mail with Attachment

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

LEARN ABOUT DEBIAN

hbpldecode

hbpldecode(1)						      General Commands Manual						     hbpldecode(1)

NAME

       hbpldecode - Decode a HBPL stream into human readable form.

SYNOPSIS

       hbpldecode [options] <hbpl-file

DESCRIPTION

       hbpldecode decodes a HBPL stream into human readable form.

       A HBPL stream is the printer langauge used by the Fuji-Xerox cp105b and the Dell 1250c printers.

COMMAND LINE OPTIONS

       These are the options that can appear on the command line.

       -d basename
	      Basename of .pbm file for saving decompressed planes.

       -h     Print hex file offsets.

       -o     Print file offsets.

       -D level
	      Set Debug level [0].

EXAMPLES

       Decode an HBPL stream file.

       $ hbpldecode -h 1250c-mono.prn
	    0:	  33%-12345X@PJL JOB MODE=PRINTER
	   1f:	  @PJL SET STRINGCODESET=UTF8
	   3b:	  @PJL COMMENT DATE=06/01/2011
	   58:	  @PJL COMMENT TIME=13:28:30
	   73:	  @PJL COMMENT DNAME=empty - Notepad
	   96:	  @PJL SET JOBATTR="@LUNA=rick"
	   b4:	  @PJL SET COPIES=1
	   c6:	  @PJL SET QTY=1
	   d5:	  @PJL SET JOBATTR="@TRCH=OFF"
	   f2:	  @PJL SET DUPLEX=OFF
	  106:	  @PJL SET BINDING=LONGEDGE
	  120:	  @PJL SET RENDERMODE=GRAYSCALE
	  13e:	  @PJL SET ECONOMODE=OFF
	  155:	  @PJL SET RET=ON
	  165:	  @PJL SET JOBATTR="@IREC=OFF"
	  182:	  @PJL SET JOBATTR="@HOAD=I0A00020F"
	  1a5:	  @PJL SET JOBATTR="@JOAU=rick"
	  1c3:	  @PJL SET JOBATTR="@CNAM=RICK-VB"
	  1e4:	  @PJL SET IWAMANUALDUP=OFF
	  1fe:	  @PJL SET IWAJAMRECOVERY=AUTO
	  21b:	  @PJL SET JOBATTR="@MSIP=NORMAL"
	  23b:	  @PJL SET PAPERDIRECTION=SEF
	  257:	  @PJL SET RESOLUTION=600
	  26f:	  @PJL SET BITSPERPIXEL=8
	  287:	  @PJL SET JOBATTR="@DRDM=RASTER"
	  2a7:	  @PJL SET JOBATTR="@TCPR=33"
	  2c3:	  @PJL SET JOBATTR="@TUCR=33"
	  2df:	  @PJL SET JOBATTR="@TTRC=33"
	  2fb:	  @PJL SET JOBATTR="@TSCR=33"
	  317:	  @PJL SET JOBATTR="@GCPR=33"
	  333:	  @PJL SET JOBATTR="@GUCR=33"
	  34f:	  @PJL SET JOBATTR="@GTRC=33"
	  36b:	  @PJL SET JOBATTR="@GSCR=33"
	  387:	  @PJL SET JOBATTR="@ICPR=34"
	  3a3:	  @PJL SET JOBATTR="@IUCR=34"
	  3bf:	  @PJL SET JOBATTR="@ITRC=34"
	  3db:	  @PJL SET JOBATTR="@ISCR=34"
	  3f7:	  @PJL SET JOBATTR="@TDFT=0"
	  412:	  @PJL SET JOBATTR="@GDFT=0"
	  42d:	  @PJL SET JOBATTR="@IDFT=0"
	  448:	  @PJL ENTER LANGUAGE=HBPL
	  461:	  RECTYPE 'A' [0x41]:
	  462:	       81 a1: 0x0
	  465:	       82 a2: 0x7
	  469:	       83 a2: 0x1
	  46d:	  RECTYPE 'C' [0x43]:
	  46e:	       91 a1: 0x0
	  471:	       92 a1: 0x1
	  474:	       93 a1: 0x1
	  477:	       94 a1: 0x0
	  47a:	       95 c2: 0x0
	  480:	       96 a1: 0x0
	  483:	       97 c3: 0x0
	  489:	       98 a1: 0x0
	  48c:	       99 a4: 1 [PAGECNT]
	  492:	       9a c4: 5104x6600 [WxH]
	  49c:	       9b a1: 0x0
	  49f:	       9c a1: 0x1
	  4a2:	       9d a1: 0x9
	  4a5:	       9e a1: 0x2
	  4a8:	       9f a1: 0x5
	  4ab:	       a0 a1: 0x8
	  4ae:	       a1 a1: 0x0
	  4b1:	       a2 c4: 5104x6600 [WxH]
	  4bb:	  RECTYPE 'Q' [0x51]:
	  4bc:	  RECTYPE 'R' [0x52]:
	  4bd:	       a3 a1: 0x0
	  4c0:	       a4 a2: 6457 (0x1939) bytes of data...
	 1dfe:	  RECTYPE 'S' [0x53]:
	 1dff:	  RECTYPE 'D' [0x44]:
	 1e00:	  RECTYPE 'B' [0x42]:
	 1dff:	  33%-12345X@PJL EOJ

FILES

       /usr/bin/hbpldecode

AUTHOR

       Rick Richardson <rick.richardson@comcast.net>
All times are GMT -4. The time now is 10:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy