Visit Our UNIX and Linux User Community


How to attach an excel file in a multipart (mime) mail


 
Thread Tools Search this Thread
Operating Systems HP-UX How to attach an excel file in a multipart (mime) mail
# 1  
Old 07-27-2009
How to attach an excel file in a multipart (mime) mail

Hello.

I need to send mails from hp-ux with 2 attachments: a text file and an excel file. So I'm composing a mime file which I will pipe to sendmail utility.

This works fine if the only attachment is the text file (i use cat command to attach text content). But I have problems with the format when I try to open the sent excel file. I have tried cat, uuencode, od... I've changed the 'encoding' (binary, base64, etc).

My code is like this (progress environment, put is like echo):

put "------------thisss isss aaa boundddaaarrryyy" skip.
put 'Content-Type: text/plain; charset=us-ascii; name="' (p_filename + '"') format "x(30)" skip.
put "Content-Transfer-Encoding: 7bit" skip.
put 'Content-Disposition: attachment; filename="' (p_filename + '"') format "x(30)" skip(1).
unix silent cat value(p_filepath).

put "------------thisss isss aaa boundddaaarrryyy" skip.
put 'Content-Type: application/octet-stream; name="' (p_filename2 + '"') format "x(30)" skip.
put "Content-Transfer-Encoding: base64" skip.
put 'Content-Disposition: attachment; filename="' (p_filename2 + '"') format "x(30)" skip(1).
unix silent uuencode value(p_filepath2) value(p_filepath2).



The output file (mime.txt) is piped to sendmail like this:
par = '-F"' + p_fullname + '" -bm -t -rxxxxx@xxxxx.com'.
unix silent cat ./tmp_cnt_mime.txt | /usr/sbin/sendmail value(par)


Any idea??
Does anyone know another solution??
# 2  
Old 07-29-2009
Only way I know is to create a csv file and save it with a .csv extension and then attach it to mailx with the uuencode utility...
Code:
echo "hello,world" > file.csv
uuencode file.csv file.csv | mailx -m -s "Excel file" your_email_addr

# 3  
Old 08-01-2009
give this a try

if you can follow - automatic date - for last month
probably a better way - take a look

ext=_FINAL_s
space=_
year=$(date +%Y)
month=$(date +%m)
monthh=$(date +%h)
day=$(date +%d)

month=$(($month-1))
if [ $month -lt 1 ]
then
year=$(($year-1))
month=12
fi

if [ $month -eq 1 ]
then monthd=JAN
elif [ $month -eq 2 ]
then monthd=FEB
elif [ $month -eq 3 ]
then monthd=MAR
elif [ $month -eq 4 ]
then monthd=APR
elif [ $month -eq 5 ]
then monthd=MAY
elif [ $month -eq 6 ]
then monthd=JUN
elif [ $month -eq 7 ]
then monthd=JUL
elif [ $month -eq 8 ]
then monthd=AUG
elif [ $month -eq 9 ]
then monthd=SEP
elif [ $month -eq 10 ]
then monthd=OCT
elif [ $month -eq 11 ]
then monthd=NOV
elif [ $month -eq 12 ]
then monthd=DEC
fi

echo $day
echo $month
echo $monthd

uuencode CP_template_$monthd$space$year$ext.xls < /cqdata10/data_0/CP_template_$
monthd$space$year$ext.html | mailx -m -s "SPECIAL Auto. e-mail - C/P - dq Stats
- for month end $monthd $year - file should be att. - from UNIX "william.g.loughran@yourcompany.com"
Bill L.
# 4  
Old 08-23-2009
Install Perl and the module MIME::Lite. Then you can just build your message and add the attachment with the correct mime information to be sent out.
It would really only take a couple of lines and give you the ability to write some code with flexibility to use in other situations.

Previous Thread | Next Thread
Test Your Knowledge in Computers #246
Difficulty: Easy
By 1973, e-mail constituted 95% of the ARPANET traffic.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Construct and Send Multipart MIME Mail

Hi, I have requirment in shell script to incorporate multipart email with both html and text. Here am giving the text version. From: any@email.com To: your@email.com Subject: Success Execution - $company - Apps PO File Report Apps PO File Report Summary: #APPS Purchase... (2 Replies)
Discussion started by: kirankumar
2 Replies

2. Shell Programming and Scripting

UNIX - how to send attach excel in mail

Hi Experts, i need your help here :confused: Need to send a report thru mail using unix shell script(AIX). can you help me to do this? . i tried "uuencode" with CSV format, but while reading report all values are in single column. i need each column values in separate cell. Thanks in... (9 Replies)
Discussion started by: newbieabc
9 Replies

3. Shell Programming and Scripting

How to attach multiple file to send mail command

Hi, i want color effect on mail as well as multiple attachment.I have code but this code is used for single attachment. I am unable to attach more than one file.:wall: I want to send two attachments -ahmed.csv and ahmed1.csv . Sample content: <html> <body> <b> Hi...</b> </body> </html> ... (1 Reply)
Discussion started by: AhmedLakadkutta
1 Replies

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

5. Shell Programming and Scripting

Script to attach file to mail

Hello, I have a .dat file containing one line. I need a script to read that line and make it part of the body and send a mail... Let's say the line is $line. I need the script to send a mail with the body "The last disposal feed is $line". Thanks (4 Replies)
Discussion started by: sfetea
4 Replies

6. Shell Programming and Scripting

How to attach a file in Linux mail command

How to attach a file in Linux mail command Hi Guys, Is there any way to attach a file in Linux mail command without using "uuencode"? i.e. Code: file=/a/b/c/d/file.txtmail -s "Giga aks" abc@123.com <<HDoc`uuencode $file $file 2>/dev/null`HDoc Here, I don;t want to use 'uuencode'... (1 Reply)
Discussion started by: rohit22hamirpur
1 Replies

7. Shell Programming and Scripting

How to attach a file & send mail thru script

In shell script how can I attach a file and send a mail. suppose if I written like the following way usr/bin/mail 'subject" "mail_id" < file. a mail goes to the mail-id with the content of file.But I want the file to be atttached to the mail.How can I get it.is there any way for this. ... (9 Replies)
Discussion started by: Mar1006
9 Replies

8. Shell Programming and Scripting

Need to attach a txt file while sending mail

Hi, I need to attach a txt file while sending mail thru Unix. Please help me out in this.. -Charan. (9 Replies)
Discussion started by: charan81
9 Replies

9. Shell Programming and Scripting

How to attach an excel file/ dat file thru unix mails

Hi. I want to attach a .xls or .dat file while sending mail thru unix. I have come across diff attachments sending options, but allthose embeds the content in the mail. I want the attachement to be send as such. Please help me out. regards Diwakar (1 Reply)
Discussion started by: diwakar82
1 Replies

10. UNIX for Dummies Questions & Answers

How to attach a file in mail?

Hi, I want to know how to send a mail in unix using mailx or mail or sendmail to send a mail with a file attached. I have read the answers from the other threads but I still don't understand. I want to do it in the command line as well as in script. Can anyone help? DO I need to use... (1 Reply)
Discussion started by: firebirdonfire
1 Replies

Featured Tech Videos