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

claws-mail-attach-warner

CLAWS-MAIL-ATTACH-WARNER(1)				      General Commands Manual				       CLAWS-MAIL-ATTACH-WARNER(1)

NAME

       claws-mail-attach-warner -- Missing attachments warning before sending

DESCRIPTION

       This manual page documents briefly the claws-mail-attach-warner

       This manual page was written for the Debian distribution because the original program does not have a manual page.

       claws-mail-attach-warner is a plugin (loadable module) for the Claws Mail mailer.

       It's  aimed  at	prevention of forgetting attachments, by warning the user if some attachment is mentioned in the mail text but no attached
       file is found in the composed mail.

USAGE

       Before using a plugin you must instruct Claws Mail to load it on startup.

       For this you must go ``Configuration'' menu on main window toolbar, open ``Plugins...'' dialog, click on the ``Load plugin...'' button  and
       select the plugin file, named attachwarner.so, and press the ``Open'' button.

SEE ALSO

       claws-mail (1), claws-mail-extra-plugins (1).

AUTHOR

       claws-mail-attach-warner was written by Ricardo Mones ricardo@mones.org

       This  manual page was written by Ricardo Mones mones@debian.org for the Debian system (but may be used by others). Permission is granted to
       copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later  version  published	by
       the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

														       CLAWS-MAIL-ATTACH-WARNER(1)
All times are GMT -4. The time now is 06:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy