APEX_MAIL To Send a E-Mail & HTML Format link In APEX

Today i am going to write a blog about sending email and HTML support message in Oracle Application Express (APEX). In APEX 5, Sending a e-mail feature is made it as very easily. Let’s go through the below steps will step by step help your sending emails (APEX_MAIL) to public user.


Download “APEX_MAIL-To-Send-a-E-Mail-HTML-Format-link-In-APEX.pdf” APEX_MAIL-To-Send-a-E-Mail-HTML-Format-link-In-APEX.pdf – Downloaded 259 times – 183 KB

How APEX_MAIL Will Help ?

In Oracle Application Express will make life easily to send mail to user by you can use the APEX_MAIL package to send an email from an APEX. This package is built on top of the Oracle supplied UTL_SMTP package. By default this dependence, the UTL_SMTP package already be installed and functioning in APEX in order to that you can use APEX_MAIL option to send mail by simply.

In Oracle Application Express, APEX_MAIL contains three procedures.

  • 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.

Sending E-Mail In APEX:

Create a one page in APEX (My case : page no is ‘5’) and add button in this page (my case : named as p5_Send_Mail) like this. The following steps will help your for send a plain text email message from an application.

To create a PL/SQL procedure to send a e-mail to the your public user:

  1. Navigate to page, my cases page no is “5”
  2. Left side of the Page Processing area under Processes, click Create.
  3. In the Create Process Wizard:
    • Enter Name for the processes and my cases “p5_Send_mail”.
    • From the Point list, select On Submit – After Computations and Validations.
    • From the Type list, select PL/SQL block, copy and paste the below code inside this block,

APEX_MAIL

APEX_MAIL

4.  In the Success Message field, enter: Mail Sent Successfully.
5.  In the Failure Message field, enter: Error Sending Mail.
6.  From the When Button Pressed list, select your button name (In my case: p5_Send_Mail). This is the send mail button that Placed in your page              for processes conditional.
7.  Make Save Option and Run your Application.
You should now receive mail from this application and check your e-mail by 2 mins later or sometimes mail receive in Spam.

Sending E-Mail In HTML Format:

The following steps will help your for send a HTML format of  email message from an application.Watch Full Movie Online Streaming Online and Download

To create a PL/SQL procedure to send a HTML  e-mail to the your public user:

  1. Navigate to page, my cases page no is “5”
  2. Left side of the Page Processing area under Processes, click Create.
  3. In the Create Process Wizard:
    • Enter Name for the processes and my cases “p5_Send_mail”.
    • From the Point list, select On Submit – After Computations and Validations.
    • From the Type list, select PL/SQL block, copy and paste the below code inside this block,

4.  In the Success Message field, enter: Mail Sent Successfully.

5.  In the Failure Message field, enter: Error Sending Mail.

6.  From the When Button Pressed list, select your button name (In my case: p5_Send_Mail). This is the send mail button that Placed in your page for processes conditional.

7.  Make Save Option and Run your Application.

You should now receive mail from this application and check your e-mail by 2 mins later or sometimes mail receive in Spam.

If you like this Blog and feel my guides useful, please share my page by using below.  Thanks!¶  Cheers!¶

Issacsha

IssacSha is a professional blog writer, who loves trying to find new things and sharing the same experience through my blog website. He loves website design, WordPress, SEO, Java, Android, HTML, Cloud Computing, SQL, PL/SQL, Blogger Tips etc and hope people will get benefit by reading my blogs related to technology.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInPinterestGoogle PlusYouTube

Leave a Reply

Your email address will not be published. Required fields are marked *