Sponsored Content
Full Discussion: Excel attachment in e-mail
Top Forums UNIX for Dummies Questions & Answers Excel attachment in e-mail Post 302218462 by joeyg on Friday 25th of July 2008 07:43:33 AM
Old 07-25-2008
Hammer & Screwdriver Excel file from unix

Two methods for this:
(a) There are specific add-ons you can obtain that allow fairly extensive use of Excel commands and functions to be created by a unix shell.
or...
(b) Create a .csv file. Excel can open (and write) .csv files. So, you could build a file along the following idea. Please note is is not complete code, but a sample of some of the commands to use. [I do many of these in my job - creating reports others can read in Excel.]

Code:
csv_f="my_excel.csv"
echo "John Doe","12 Main Street Boston MA",100,10 >>$csv_f
echo "Karthi Key","52 Commercial Way New York NY",200,5 >>$csv_f
uuencode "$csv_f" "$csv_f" | mailx -s "important excel" karth@anywhere.com

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

mail attachment

This question has been asked many time before. I did search other questions. But was not able to work out. Really sorry for repeating the same question. I have mail and mailx and sendmail installed. It Tried this uuencode FILENAME.txt FILENAME.txt | mail mymail@yahoo.com the attachment... (3 Replies)
Discussion started by: sushrut
3 Replies

2. Shell Programming and Scripting

Send email with attachment in form of excel in unix

Hi, I have a shell script which send email with an attachment in the form of an email. However, the when I open the attachment, all the data comes in one column. How do I format the data in the excel sheet while sending the email? Thanks (8 Replies)
Discussion started by: bdebroy
8 Replies

3. UNIX for Advanced & Expert Users

mailx commannd - Mail and Attachment in same mail

Hi , I am using mailx command for sending the mails. Rightnow I am sending the attachment (by using uuencode $filename) as a seperate mail.I wanna send the attachment also with the same mail. (6 Replies)
Discussion started by: sharif
6 Replies

4. Shell Programming and Scripting

Mail attachment with unix mail

Hi Could someone help me with the details on how to send an attachment through mail in unix. I have an html file in my unix machine and I want this to be send to some mail id, plese help with the steps. Regards Ajay (2 Replies)
Discussion started by: ajaykumarboyana
2 Replies

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

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 . cat Employee.sql SET VERIFY OFF SET PAGESIZE 200 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON - HEAD... (0 Replies)
Discussion started by: mani_isha
0 Replies

6. Shell Programming and Scripting

MIME - HTML mail with Excel attachment - Please help!

#!/bin/ksh ( echo "MIME-Version: 1.0" echo "Content-Type: multipart/mixed; boundary=frontier" echo "--frontier" echo "Content-Type: text/html" echo "Content-Disposition: inline" echo "\n" echo "<html><body><h1>this is html formatted text</h1></body></html>" echo "--frontier" echo... (1 Reply)
Discussion started by: thulasidharan2k
1 Replies

7. Shell Programming and Scripting

mailx not sending excel attachment properly

Hi, I am trying to send email with attachment using mailx command. I am using the folowing command: uuencode XX_HWSW_BUYERWISE_88963631_1.xls XX_HWSW_BUYERWISE_88963631_1.xls | mailx -s "Test Mail as Attachment" oracleams@xyz.com I get the email in the inbox. However, when I try to open the... (5 Replies)
Discussion started by: asp_julius
5 Replies

8. Shell Programming and Scripting

Excel file attachment showing data in single column

Hi All, found similar posts, but not exatcly what i wanted. I have an text file like below and am trying to send mail as an excel file but when i get the excel file as the attachment, all the data is coming in the first column. I need below data in 4 columns. Unix file Name,ID,Trade,Date... (3 Replies)
Discussion started by: robinbannis
3 Replies

9. UNIX for Beginners Questions & Answers

Excel attachment in e-mail

i am trying to get an SQL output into an excel attachment and the other output into mail body as excel format. i am getting the excel format in the mail body, but i am not getting the excel attachment. and the output is coming in one cell in the excel. is it possible to get the excel output with... (11 Replies)
Discussion started by: maddelav
11 Replies

10. UNIX for Beginners Questions & Answers

Sending Excel Files as attachment using Mail

Hie, I need to attach an .xlsx file as an attachment to a mail. I have used the mail option but i dont think there is anything for attachment. Can you show me how else can i do it? I am not allowed to install mutt since it is a workplace and they have their restrictions. And its a Bash Shell (2 Replies)
Discussion started by: barryallen
2 Replies
Cone(C)

CONE(1) 						  Cone: COnsole Newsreader And E						   CONE(1)

NAME
cone - Read and send E-mail messages SYNOPSIS
cone [-r] [-c directory] USAGE
Cone is a console newsreader and E-mail. It is an interactive program for reading and sending E-mail messages. Cone is designed to be intuitive and easy to learn. Starting Cone for the first time displays two links: one for the default system mailbox, and a second link to a quick online tutorial. The online tutorial provides a brief overview of using Cone for reading and sending E-mail. Pressing Q on most screens exits Cone. Cone tries to gracefully log out and shut down all server connections. If Cone cannot log out of a remote server because the remote server is down, press CTRL-C (after Q to terminate Cone). Use CTRL-Z to temporarily suspend Cone and drop back to the shell prompt. Cone remains suspended in the background, and may be restarted by using the shell's fg command. Note Connections to remote mail servers may be disconnected for inactivity if Cone remains suspended for a prolonged period of time. When suspended, Cone cannot maintain any active connections to remote mail servers. The -c option names a directory where Cone saves its configuration files, and defaults to $HOME/.cone. The configuration directory will be created, if necessary. The -r option recovers a backup copy of Cone's configuration file. This option is primarily used when remote configuration is enabled, but the folder that contains Cone's configuration on a remote server was deleted, or is not available. In all cases, Cone makes a daily local configuration file backup. The -r option searches for local configuration file backups, and offers an option to restore the backup copy. Reading local mail with Cone Cone reads local mail from either maildirs (the preferred format) or mailbox files (or "mboxes"). When mboxes are used, Cone does not read the system mailbox file directly (usually /var/spool/something). All messages in the system mailbox are automatically moved to $HOME/Inbox, which is then accessed as if it was the system mailbox. Starting Cone for the first time on an mbox-based system automatically copies all existing mail from the system mailbox file to $HOME/Inbox. This is an intentional design choice. Normal user application cannot create new files in /var/spool; all they can do is read the mailbox file from /var/spool. Therefore, the only way to update the mailbox file is by rewriting it from scratch (more or less). While the mailbox file is in the process of being rewritten, if the Cone process is interrupted, or killed, the resulted in a corrupted system mailbox. There are way to minimize this vulnerability, but it cannot be eliminated completely. Some Linux kernels use an "OOM killer" that may terminate any process when the system memory is low. There is no way to completely prevent corrupted system mailbox files on those kernels. Cone uses an alternative way of updating mboxes. Cone updates mboxes by creating a new mbox file separately, then replacing the original mbox file with the new version. Unfortunately this cannot be done with the system mailbox file, because of the restricted access rights on the system spool directory. To solve this problem Cone automatically copies the system mailbox file to $HOME/Inbox, each time the system mailbox file is opened and whenever new mail is available. Viewing MIME attachments Cone displays text and simple HTML content by itself. Other kinds of attachments may be viewed by using a helper script. Cone invokes a helper script to open a MIME attachment. The helper script's name is "TYPE.SUBTYPE.filter", where "TYPE" and "SUBTYPE" corresponds to the MIME type and subtype, accordingly. Cone looks for helper scripts in $HOME/.cone (or the directory specified by -c) and in /usr/share/cone. For example, a helper script named "IMAGE.GIF.filter", if installed, is invoked to process image/gif MIME attachments. Helper scripts Cone runs each helper script twice: TYPE.SUBTYPE.filter check type/subtype When the first argument is "check", the helper script should terminate with a zero exit code if it is willing to process an attachment whose MIME type is specified by the second argument. A script or a program that's has multiple "TYPE.SUBTYPE.filter" links may use the second argument to identify the attachment's mime type. If the helper script is unable to process the attachment, at this time, it should terminate with a non-zero exit code. The default helper script for image attachments terminates with a non-zero exit code if the DISPLAY environment variable is not initialized. When invoked from an X-Windows terminal, image attachments will be automatically displayed; and image attachments are ignored otherwise on non-graphical consoles. TYPE.SUBTYPE.filter filter type/subtype filename If the helper script initially terminates with a zero exit code, it will be invoked again after the MIME attachment is downloaded and decoded. The first argument will be "filter", and the attachment's filename is specified by the third argument. Note This is a temporary file, whose extension will not necessary be the file extension associated with this MIME type. The helper script should read and process the file specified by the third argument. Cone interprets anything the helper script writes to standard output as HTML. Note Cone waits until the helper script terminates before displaying the rest of the message. Most helper scripts should run in the background. However, note that Cone removes the temporary file when the original message is closed; the temporary file may be removed any time after the helper script terminates. The helper script should make its own private copy of the file, if necessary. Activating URLs Cone has limited ability to activate URLs in HTML messages. Cone handles "mailto:" URLs by itself. For other URLs Cone runs /usr/share/cone/method.handler with the URL passed as an argument. Cone installs http.handler (hard linked to https.handler). This script checks if firefox or mozilla binaries are found in the current PATH, and runs them. Note Cone also looks method.handler in $HOME/.cone (or the directory specified by -c) in addition to /usr/share/cone. FILES
$HOME/.cone Configuration files, and other application data. May be modified by the -c option. /usr/share/cone/IMAGE.GIF.filter, /usr/share/cone/IMAGE.JPEG.filter, /usr/share/cone/IMAGE.PNG.filter, /usr/share/cone/APPLICATION.PDF.filter Default helper scripts distributed with Cone. SEE ALSO
mailtool(1), sendmail(8). AUTHOR
Sam Varshavchik Cone(C) 04/04/2011 CONE(1)
All times are GMT -4. The time now is 12:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy