what's the message header you got in thunderbird?
Have you set the "Disposition" option to "attachment" rather than the default 
"inline"?

Regards.


Sun, 06 Feb 2011 15:38:44 -0800 письмо от David Newman 
<dnew...@networktest.com>:

> Greetings. I'm looking for a way to run a query against a SQL database,
> save the result into a file, and then attach the file to an email.
> 
> The DBD::mysql and MIME::Lite modules handle the SQL query and email
> attachment respectively, but at least with the MIME 'text/csv' format
> there's a problem: In Thunderbird and Outlook, the attached file appears
> embedded in the message body. Here's an example in Thunderbird:
> 
> -----
> 
> Here's the data you requested.
> 
> 
> somefile.csv
> 
> id,date_created,date_updated,ip_address,firstname,lastname,title,organization,email,country
> 1,2010-05-13 07:48:18,,1.2.3.4,Homer,Simpson,Safety Dept.,Burns Nuclear
> Energy,chunkylove...@aol.com,USA
> 2,2010-05-13 09:22:05,,5.6.7.8,Hank,Hill,Propane Specialist,Strickland
> Propane,,USofFrickinA
> ...
> 
> -----
> 
> Having the CSV output appear in the message body is a problem for the
> nontechnical audience that will receive this message.
> 
> Is there a module that will put the query output in native Excel format,
> or a MIME format that will attach the CSV file so that its contents do
> not appear in the message body (i.e., it just shows up as an attached file)?
> 
> thanks
> 
> dn
> 
> 
> -- 
> To unsubscribe, e-mail: beginners-unsubscr...@perl.org
> For additional commands, e-mail: beginners-h...@perl.org
> http://learn.perl.org/


-- 
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/


Reply via email to