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.
Thanks in advance,
Jagadeesh
Hi there..
I need a proper "mutt" command to send a mail with html body and html attachment at a time.
Also if possible let me know the other commands to do this task.
Please help me.. (2 Replies)
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
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)
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)
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)
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)
I am using Sun Solaris ver. 5.10 and trying to send an HTML table in email body using mail command in C shell script.
I tried following commands:-
#1
mail -m "MIME-Version: 1.0;Content-type:text/html;charset=UTF-8" receiver@mail.com < file.html #2
mail -m "Content-type: text/html;" -s "This... (4 Replies)
hi ,
i have written below piece of code to meet the requirement but i am stuck in the logic here.
the requirement are:
1) to send the sql out put to email body with proper formatting.
2) if count_matching = Yes then mail should triggered with the subject line ... (10 Replies)
Discussion started by: itzkashi
10 Replies
LEARN ABOUT DEBIAN
ledgersmb::mailer
LedgerSMB::Mailer(3pm) User Contributed Perl Documentation LedgerSMB::Mailer(3pm)NAME
LedgerSMB::Mailer - Mail output for LedgerSMB
SYNOPSIS COPYRIGHT
#====================================================================
# LedgerSMB
# Small Medium Business Accounting software
# http://www.ledgersmb.org/
#
# Copyright (C) 2006
# This work contains copyrighted information from a number of sources
# all used with permission.
#
# This file contains source code included with or based on SQL-Ledger
# which # is Copyright Dieter Simader and DWS Systems Inc. 2000-2005
# and licensed under the GNU General Public License version 2 or, at
# your option, any later version. For a full list including contact
# information of contributors, maintainers, and copyright holders,
# see the CONTRIBUTORS file.
#
# Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork):
# Copyright (C) 2002
#
# Author: DWS Systems Inc.
# Web: http://www.sql-ledger.org
#
# Contributors:
#
# Original Author and copyright holder:
# Dieter Simader dsmimader@sql-ledger.com
#====================================================================
METHODS
LedgerSMB::Mailer->new(...)
Create a new Mailer object. If any arguments are passed in, a message that uses them will be automatically prepared but not sent.
$mail->prepare_message(to => $to, from => $from, ...)
Prepares and encodes base message for sending or adding attachments.
Arguments
to, from, cc, bcc
Address fields for the email.
subject
The subject for the email.
message
The message body for the email.
contenttype
The conttent type for the body of the message, not for any attachments.
notify
Sets the Disposition-Notification-To header (read receipt request) for the message. This header will only be added if a from address
is set.
$mail->attach(data => $data, file => $file, filename => $name, strip => $strip)
Add an attachment to the prepared message. If $data is specified, use the value of that variable as the attachment value, otherwise attach
the file given by $file. If both a file and data are given, the data is attached. filename must be given and is used to name the
attachment.
$strip is an optional string to remove from the filename send with the attachment.
$mail->send
Sends a prepared message using the method configured in ledgersmb.conf.
perl v5.14.2 2012-03-26 LedgerSMB::Mailer(3pm)