Sponsored Content
Top Forums Shell Programming and Scripting HTML table in email body using C Shell Post 302942658 by blackrageous on Thursday 30th of April 2015 01:08:45 PM
Old 04-30-2015
It's not clear what you mean. Are you trying to receive html formatted mail in your mail client? What is your mail client? When you say, you get "required result" if you send as an attachment, does this mean that when you click on the attachment it opens it up in a browser?

Also, never name a script test since this is a shell builtin.
Code:
test Command

Purpose

       Evaluates conditional expressions.

---------- Post updated at 12:07 ---------- Previous update was at 11:50 ----------

This works...

Code:
[josephgr@truth2 josephgr] cat foo.sh
cat <<EOD
From:  justadude@foo.bar.com
To: another.dude@someplace.com 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="UTF-8"
 <!DOCTYPE html>
<html>
<table id="t01">
  <tr>
    <th>First Name</th>
    <th>Last Name</th>
    <th>Points</th>
  </tr>
  <tr>
    <td>Jill</td>
    <td>Smith</td>
    <td>50</td>
  </tr>
  <tr>
    <td>Eve</td>
    <td>Jackson</td>
    <td>94</td>
  </tr>
  <tr>
    <td>John</td>
    <td>Doe</td>
    <td>80</td>
  </tr>
</table>
</html>
EOD

---------- Post updated at 12:08 ---------- Previous update was at 12:07 ----------

This works

./foo.sh | sendmail -t

Code:
[josephgr@truth2 josephgr] cat foo.sh
cat <<EOD
From:  justadude@foo.bar.com
To: another.dude@someplace.com 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="UTF-8"
 <!DOCTYPE html>
<html>
<table id="t01">
  <tr>
    <th>First Name</th>
    <th>Last Name</th>
    <th>Points</th>
  </tr>
  <tr>
    <td>Jill</td>
    <td>Smith</td>
    <td>50</td>
  </tr>
  <tr>
    <td>Eve</td>
    <td>Jackson</td>
    <td>94</td>
  </tr>
  <tr>
    <td>John</td>
    <td>Doe</td>
    <td>80</td>
  </tr>
</table>
</html>
EOD


Last edited by blackrageous; 04-30-2015 at 01:56 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Referring to attached images in html email body through mailx

encoding type for images? (5 Replies)
Discussion started by: biswasbaishali
5 Replies

2. UNIX for Advanced & Expert Users

Email with multiple attachments & HTML body

I have a html file: # cat sample.html <html> <body> Sample HTML file</p> </body> </html> And I have two excel sheets (sheet1.xls & sheet2.xls) I want to send an email by having the sample.html as the message body and two spreadsheets as the attachments. I tried using the below command:... (12 Replies)
Discussion started by: BHM
12 Replies

3. UNIX for Advanced & Expert Users

Mutt for html body and multiple html & pdf attachments

Hi all: Been racking my brain on this for the last couple of days and what has been most frustrating is that this is the last piece I need to complete a project. There are numerous posts discussing mutt in this forum and others but I have been unable to find similar issues. Running with... (1 Reply)
Discussion started by: raggmopp
1 Replies

4. Shell Programming and Scripting

Email body not formatted with html and sendmail

Hi All, I am trying to send the contents of a file as email body. I am using html email and sendmail option of unix. I am using the below piece of code for the same : #!/usr/bin/ksh export MAILTO="email@domain.com" export SUBJECT="Report" export BODY="file_directory_path/test_file.txt"... (1 Reply)
Discussion started by: rockygsd
1 Replies

5. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies

6. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies

7. UNIX for Dummies Questions & Answers

Convert Txt file to HTML table and email

Hi all I need help converting a text file into a html table in bash and I need to email this table. The text file looks like the below. Two columns with multiple rows. Top row being header. Application Name Application Status Application 1 Open Application 2 ... (2 Replies)
Discussion started by: hitmanjd
2 Replies

8. Shell Programming and Scripting

Regarding guidance related to HTML table in email body

Hello All, I have a query here. I am sending an HTML table(which I am creating it by a call to REST API, in a LINUX box) and from there I have to send it into an email. So following are the poins on same: As data is not static so it is writing Dynamic data and creating HTML file. There is... (9 Replies)
Discussion started by: RavinderSingh13
9 Replies

9. Shell Programming and Scripting

Postgre Query results as Email HTML table

Hello, I'm trying to send email from Greenplum query results as HTML table with status Red/Green Select Server, Last_Date from Table; Results Server, Last_Date Prod, 2018-04-09 Final email Output in HTML format Server Status LastDate Prod GREEN(BOX) 2018-04-09 (if... (2 Replies)
Discussion started by: krux_rap
2 Replies

10. UNIX for Beginners Questions & Answers

Not able to generate table in email body

Below is the code snippet and I'm not able to generate the table in email, output email has nothing if ; then echo "File $fName exists." awk -F "," ' BEGIN { print "MIME-Version: 1.0" print "Content-Type: text/html" print "Subject: Out OF Network Fee - Portfolio Level Stats" print... (1 Reply)
Discussion started by: vyomdev
1 Replies
TNEF(1) 						      General Commands Manual							   TNEF(1)

NAME
tnef - decode Microsoft's Transport Neutral Encapsulation Format SYNOPSIS
tnef [options] [FILE] tnef {--help | --version} DESCRIPTION
This manual page documents the tnef filter. tnef decodes e-mail attachments encoded in Microsoft's Transport Neutral Encapsulation Format (hereafter, TNEF), which "wraps" Microsoft e-mail attachments. Unfortunately, these "wrapped" attachments are inaccessible to any e-mail client that does not understand TNEF. Fortunately, the tnef fil- ter can be used by any MIME-aware client to unpack these attachments. OPTIONS
-f FILE, --file=FILE use FILE as input ('-' denotes stdin). When this option is omitted, tnef reads data from stdin. -C DIR, --directory=DIR unpack file attachments into DIR. -x SIZE, --maxsize=SIZE limit maximum size of extracted archive (bytes) -t, --list list attached files, do not extract. -w, --interactive, --confirmation ask for confirmation for every action. --overwrite when extracting attachments, overwrite existing files. --number-backups when extracting attachments, if file FOO will be overwritten, create FOO.n instead. --use-paths honor file pathnames specified in the TNEF attachment. For security reasons, paths to attached files are ignored by default. --save-body FILE Save message body data found in the TNEF data. There can be up to three message bodies in the file, plain text, HTML encoded, and RTF encoded. Which are saved is specified by the --body-pref option. By default the message bodies are written to a file named message with an extension based upon the type (txt, html, rtf). --body-pref PREF Specifies which of the possibly three message body formats will be saved. PREF can be up to three characters long and each charac- ter must be one of 'r', 'h', or 't' specifying RTF, HTML or text. The order is the order that the data will be checked, the first type found will be saved. If PREF is the special value of 'all' then any and all message body data found will be saved. The default is 'rht'. --save-rtf FILE DEPRECATED. Equivalent to --save-body=FILE --body-pref=r -h, --help show usage message. -V, --version display version and copyright. -v, --verbose produce verbose output. --debug enable debug output. EXAMPLE
The following example demonstrates typical tnef usage with a popular Unix mail client called "mutt". Step 1 -- Configure ~/.mailcap Mutt can't use tnef for its intended purpose until an appropriate content type definition exists in ~/.mailcap . Here's a sample defini- tion: application/ms-tnef; tnef -w %s This mailcap entry says that whenever the MIME content type: application/ms-tnef is encountered, use this command to decode it: tnef -w %s The latter command string invokes tnef, specifying both the -w option and the attachment (created as a temporary file) as command line arguments. Step 2 -- Add The Filter To $PATH Mutt can't invoke tnef if the filter isn't accessible via $PATH. Step 3 -- Test Mutt Use mutt to read a message that includes a TNEF attachment. Mutt will note that an attachment of type "application/ms-tnef is unsup- ported". Press the "v" key to open mutt's "view attachment" menu. Move the cursor over the TNEF attachment and press the enter key to "view" the attachment. Mutt will launch tnef and invoke it using the command line syntax specified in ~/.mailcap (step 1). tnef then decodes all file(s) included in the TNEF attachment, prompting for confir- mation prior to creating an individual file (refer to -w option above). -w is useful here because it gives the end user a chance to view the filename(s) included in the mail message. Note that Mutt's attachment menu also supports a pipe option, which permits the user to pipe attachments to an external filter (how conve- nient). So, to list the contents of a TNEF attachment prior to decoding it, press the "|" key and enter this command: tnef -t SEE ALSO
metamail(1), mailcap(4), mutt(1), other email clients. AUTHOR
Mark Simpson. REPORTING BUGS
Report bugs to Mark Simpson <verdammelt@users.sourceforge.net> OTHER REFERENCES
This web page: http://support.microsoft.com/support/kb/articles/Q136/2/04.asp describes how to configure Microsoft email clients so that the TNEF format is disabled when sending messages to non-TNEF-compatible clients. Filter TNEF MIME Decoder TNEF(1)
All times are GMT -4. The time now is 06:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy