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!

Oracle apex : Send email after the Save record

SANPATMay 26 2024

Dear Support Team

I am trying to configure the Oracle apex form after i save the record . followed the following process but email is not sent when check the administrative Mail Queue all the mails are showing in Queue but its not sent. i had done the following steps :

Steps to Create and Send an Email in Oracle APEX

Create the Email Template:

  • Navigate to Shared Components.
  • Under Email, select Email Templates.
  • Click Create to make a new email template.
  • Fill in the details:
    • Template Name: Send Email
    • Static Identifier: SEND_EMAIL
    • Email Subject: Leave (#NAME#) Confirmed!
    • Header: <b style="font-size: 24px;">Leave Request</b>
    • Body:
      <strong>Hello #NAME#</strong>,<br>
      <br>
      Thank you for placing your Leave Requests!<br>
      <br>
      <strong>Leave Request Details</strong><br>
      <br>
      <table width="100%">
      <tr>
      <th align="left">Employee ID</th>
      <td>#EMP_ID#</td>
      </tr>
      <tr>
      <th align="left">Name</th>
      <td>#NAME#</td>
      </tr>
      <tr>
      <th align="left">Leave Type</th>
      <td>#LEAVETYPE#</td>
      </tr>
      <tr>
      <th align="left">Start Date</th>
      <td>#STARTDATE#</td>
      </tr>
      <tr>
      <th align="left">End Date</th>
      <td>#ENDDATE#</td>
      </tr>
      </table>
      <br>
      <br>
      <!-- <a href="https://g60ecef9140270e-slzce26ywoul36ul.adb.uk-cardiff-1.oraclecloudapps.com/ords/f?p=16:&P16_ID.">
      Click here to view the employee leave details
      </a> -->
      Configure the Data Entry Form:
    • Go to the page with your data entry form.
    • Create a button labeled Send Email.

Create the Process to Send Email:

  • Add a new process to send the email.
  • Set the process details:
    • Name: Send Email
    • Type: Send Email
    • From: sanjay.pathak@primepakindustries.com
    • To: sanjay.pathak@primepakindustries.com (for testing; replace with the appropriate recipient)
    • Email Template: Select your created template (Send Email)
    • Placeholders: Map the fields to the placeholders in your email template.

Set Process Settings:

  • Point: After Submit

  • Success Message: Email sent successfully

    Kindly suggest what more i need to do to send the email.

    Sanjay

Comments
Post Details
Added on May 26 2024
13 comments
1,327 views