You can use the APEX_MAIL package to send an email from an Oracle Application Express application. APEX_MAILcontains three procedures for sending, delivering and adding attachments to emails.
Use APEX_MAIL.SEND to send an outbound email message from your application. Use APEX_MAIL.PUSH_QUEUE to deliver mail messages stored in APEX_MAIL_QUEUE. Use APEX_MAIL.ADD_ATTACHMENT to send an outbound email message from your application as an attachment.
Example:
BEGIN
APEX_Mail.Send( 'to@email-address.com', 'from@email-address.com',
'This is some test plain text',
'This is some test <b>HTML</b>',
'Test Email Subject' );
APEX_Mail.Push_Queue;
END;
/
Note:
There is a built in limit of 5000 emails in any given 24 hour period. If you try to send more, you get an error.
To learn more, see APEX_MAIL in Oracle Application Express API Reference.