A Joomla CLI script to send database query output as a CSV attachment via email

image from: https://pixabay.com/en/linux-window-terminal-command-154766/

This Joomla CLI script lets you send a DB query output as a CSV attachment via Email.

You need to have a working Joomla website instance with emails setup done.

PHP Joomla CLI Script:
To use this:
1. Open terminal, Browse to Joomla root

cd /var/www/my-joomla-site

2. Execute PHP file 

php cli/joomla-cli-script-email-csv-attachment.php

3. You will see this as o/p on successful email sending 

Email sent

You can also setup cronjob to automate email sending.

Setting up POP3 for Hotmail account on Android phone

Here are the steps to setup a POP3 account for hotmail on your android phone

1. Click on Add Account

a. Enter Full username

b. Enter password

Click on Manual Setup

2. Incoming POP3 Mail Server Setting :

User Name : user@hotmail.com

Password : your email password

Incoming Mail Server/Pop3 Server : pop3.live.com

Port : 995

Security Type : SSL

Click on Next.

If settings are OK and password is valid, you will be asked to enter outgoing mail server settings-

3. Outgoing POP3 Mail Server Setting :

Outgoing Mail Server/SMTP Server : smtp.live.com

Port : 587

Security (Port)/Security Type : SSL/TLS

User Name : user@hotmail.com

Password : your email password

4. Configure Account options as you want.

5. Set up an account name for this account.

That's it!