Email SQL*Plus output as HTML
Hi, i'd like to email my SQL*Plus query output as HTML. I was able to make it email the output but its all in plain text.
here is my simple shell script below:
#!/bin/ksh FROM="migs.isip.23@gmail.com" TO="migs.isip.23@gmail.com" SUBJECT"=This email has html contents" CONTENTS="/home/mail_text.html" HEADER="From: ${FROM} \nTo: ${TO} \nSubject:${SUBJECT} \nContent-Type: text/html; charset=us-ascii \nContent-Transfer-Encoding: 7bit \nMIME-Version: 1.0" sqlplus -s apps/dfw_lower <<END_OF_SQL SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON - HEAD "<TITLE>Department Report</TITLE> - <STYLE type='text/css'> - <!-- BODY {background: #FFFFC6} --> - </STYLE>" - BODY "TEXT='#FF00Ff'" - TABLE "WIDTH='90%' BORDER='5'" COLUMN DEPARTMENT_NAME HEADING 'Invoice Number' ENTMAP OFF COLUMN CITY HEADING 'Invoice Date' SPOOL $
0