Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I email output of a query based on a schedule

David DLimaJul 17 2025

Hi,

I have a requirement where I need to send out an email from Oracle Apex everyday. The output of my query cannot be an attachment. The output should be in the body of the email properly formatted.

I tried using Automation but it is firing for each record of the output. For e.g. if there are 3 records in the output, I receive 3 emails which is not the requirement.

Apart from Automation is there any other way to send out the email periodically?

Any help is greatly appreciated.

Regards

David

This post has been answered by Utkarsh Ranjan on Jul 17 2025
Jump to Answer
Comments
Post Details
Added on Jul 17 2025
8 comments
89 views