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

Sponsored Content

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

03-30-2010

Registered User

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...

mani_isha

View Public Profile for mani_isha

Find all posts by mani_isha

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

LEARN ABOUT DEBIAN

mlmmj-send

mlmmj-send(1)						      General Commands Manual						     mlmmj-send(1)

NAME

       mlmmj-send - send mail to a mailinglist or similar

SYNOPSIS

       mlmmj-send [-L /path/to/list | -l listctrl] -m /path/to/mail [-a] [-D] [-F] [-h] [-o] [-r] [-R] [-s] [-T] [-V]

       -a: Don't archive the mail

       -D: Don't delete the mail after it's sent

       -F: What to use as MAIL FROM:

       -h: This help

       -l: List control variable.

       -L: Full path to list directory

       -m: Full path to mail file

       -o: Address to omit from distribution (normal mail only)

       -r: Relayhost IP address (defaults to 127.0.0.1)

       -R: What to use as Reply-To: header

       -s: Subscribers file name

       -T: What to use as RCPT TO:

       -V: Print version

DESCRIPTION

       This binary is used to send all kinds of mail to mlmmj managed mailinglists, but can potentially be used standalone for sending mails.

       The only option that is not self explanatory is the -l list control option:

	      '1' means 'send a single mail'

	      This is used together with -F and -T to send one mail to one recipient.

	      '2' means 'mail to moderators'

	      Used for sending mails to the moderators of a list.

	      '3' means 'resend failed list mail'

	      '4' means 'send to file with recipients'

	      '5' means 'bounceprobe'

	      '6' means 'single listmail to single recipient'

BUGS

       This  manual page is very scarce documentation of the mlmmj-send binary. The reason for this is that it's really not supposed to be used by
       any human, but only supposed to be invoked from other mlmmj binaries. So in case more documentation is needed, please read the source.

AUTHORS

       This manual page was written by the following persons:

       Soren Boll Overgaard <boll@debian.org> (based on html2man output)

       Mads Martin Jorgensen <mmj@mmj.dk>

mlmmj-send							   January 2010 						     mlmmj-send(1)