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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,266 views