Allow to send the result of a query (made with the module sql_export) by mail.
auto_awesome What this module does
AI-generated from the code · Odoo 18.0Send the CSV result of a saved SQL query by email to selected users or partners, either manually or automatically on a schedule.
This module extends the SQL Export feature so a saved SQL query can be emailed as a CSV attachment.
On the SQL query form you get a new "Mail" tab where you can pick the users and partners who should receive the report. A "Create Cron" button appears once users are selected, and it creates a scheduled action that runs the query and sends the email automatically.
Business rules are enforced: users and partners must have an email address, and a query that needs parameters to be filled in cannot be sent automatically by email. Queries that use the company or user parameter cannot be sent directly to partners.
When a scheduled action runs, the query is executed per company or per user as needed, and the resulting CSV file is attached to an email built from the "SQL Export" email template. A "File Not Empty" option lets you skip sending when the query returns no rows.
The module touches sql.export, res.users, res.partner, ir.cron, mail.template and mail.mail.
Depends on
Models and fields (1)
- sql.export · extends an existing modelcron_ids, mail_user_ids, mail_condition, mail_partner_ids
Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 6 confirmed, 3 with no information of 9 versions.
Sources · Odoo 14.0
Confirmed on 2026-11-03 in branch 14.0 of OCA/server-tools.
terminal Installation and usage
OCA documentation · Odoo 18.0Configuration
Source · Odoo 18.0To configure this module, you need to:
- Go to the sql query for which you want users to be notified by e-mail.
- Add users to be notified in the field Users Notified by e-mail.
- Click on the button create a cron and then configure the cron to run when you want to. If you already have created a cron for another query, you can use it again for other queries
No verified information in OCA: Installation, Usage.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.