<div>
You may use mutt to send file as an attachment.<br />
<br />
mutt -s &quot;mail-subject&quot; -a /tmp/result.txt mail-id@host.ext &nbsp;&lt; mail-body-file.txt<br />

</div>


You may use mutt to send file as an attachment.

mutt -s "mail-subject" -a /tmp/result.txt mail-id@host.ext  < mail-body-file.txt


<div>
<div class="content wysiwyg-content">
I have an ecommerce site that currently allows me to run transaction reports on demand.<br />
<br />
However, I want to have the reports run automatically, every day at 0100am.<br />
<br />
I imagine this could be done with a crontab and some kind of query to pull the relevant data from the MySQL database, format it into a csv file, then send the csv as an attachment to a specified email address.<br />
<br />
Is there a software tool that will allow me to do all of the above?<br />
<br />
Or is there a relatively easy way to implement it with a crontab set to execute a script that will do that?<br />
<br />
I have very limited programming skills so it would be great to find an existing script that I could adapt to &nbsp;my site. Thanks in advance!<br />
<br />
ps. my site is hosted on a unix VPS, administrated via Plesk. Please let me know if more info is required
</div>
</div>


I have an ecommerce site that currently allows me to run transaction reports on demand.

However, I want to have the reports run automatically, every day at 0100am.

I imagine this could be done with a crontab and some kind of query to pull the relevant data from the MySQL database, format it into a csv file, then send the csv as an attachment to a specified email address.

Is there a software tool that will allow me to do all of the above?

Or is there a relatively easy way to implement it with a crontab set to execute a script that will do that?

I have very limited programming skills so it would be great to find an existing script that I could adapt to  my site. Thanks in advance!

ps. my site is hosted on a unix VPS, administrated via Plesk. Please let me know if more info is required

Daily export MySQL reports to email

Within Internet message handling services (MHS), a message transfer agent or mail transfer agent (MTA) or mail relay is software that transfers electronic mail messages from one computer to another using a client–server application architecture. A MTA implements both the client (sending) and server (receiving) portions of the Simple Mail Transfer Protocol (SMTP). The terms mail server, mail exchanger, and MX host may also refer to a computer performing the MTA function. The Domain Name System (DNS) associates a mail server to a domain with mail exchanger (MX) resource records containing the domain name of a host providing MTA services.

Email Servers

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.