Summary APEX Mail (APEX Mail #10)


Everything you need to know about sending emails with Oracle APEX has been described in the previous blogs. At the end of this series we would like to give a summary and conclusion of this. So let's move on to the last article in our series.

#10 Summary APEX Mail

APEX offers almost everything out-of-the-box that you need to send high quality emails easily. A lot can be implemented simply and declaratively. Here you will find once again all important topics we have listed.

1. Sending emails with "E-Mail Templates"

We have started the series with sending an e-mail template without having to write any further program code for it. Since APEX version 21.2 it is easier than ever to send emails with templates. Everything can be configured declaratively in APEX Builder. In this blogpost we have described how to send an email without writing any additional code. Read here how it works

2. Sending emails with the "APEX_MAIL" API

In the second blog post we described how easy and simple it is to send email templates with a few lines of PL/SQL code even in an APEX version older than 21.2. Read here how we described it and discover the used "APEX_MAIL" API.

3. Preview of your email

Next, we described how to preview the email before sending it. This can be very handy, especially if the content of the email is dynamic. Read here how we described it.

4. Sending emails with attachment

Important and often needed is also adding attachments to an email. Accordingly, we have of course included this in our series and described it. Read here what options you have and how it works.

5. Embedding images in an email

In the 5th article we described how to embed or display images in an email. As so often, there are several options. Especially APEX version 21.2 makes life much easier for us developers. Read here which possibilities we have described.

6. Display tabular data in an email

Next, we showed you how to display tabular data in an email template. Surely there are several approaches, but with the one described here we have already achieved a good goal.Read how we did it here.

7. Checking the mail log and queue

In the 7th blog post we have listed how you can check which emails are in the queue, which have been sent successfully or if an error occurred during sending. Monitoring is very important and should not be neglected. Read here how you can do that.

8. Including a link in an email to an APEX App

Next, we showed you how to insert a hyperlink in an email that redirects you to an APEX application. It's not that tricky, but there are a few details to keep in mind. So read here how we described it.

9. Advanced email techniques

To wrap up this series, we've listed a few more techniques, tips and tricks, do's and don'ts, or what we struggled with. Maybe it will help you in creating your own email templates. So give it a try and read some final words here.


In conclusion, we can say that APEX makes it very easy for developers to send well-structured emails. Pretty much everything you need is provided out of the box and most of it can be developed with little to no code. According to the "lowcode" motto. Of course, a few details should be considered here as well. Will the recipient read their email on mobile phone? Which email clients do I write to? Should images be displayed? There are answers for everything and APEX will do a lot for us. Our impression is that APEX has done an excellent job here, so that we can and should send emails without hesitation.

So try it out and let us know if we forgot to describe something or if you have any hints for us.

Finally here is the link for our demo app
There you can also download a copy of the demo app ;-)

Happy APEXing!!!


  1. Excellent Series Timo !
    Will wait for your next series.

  2. Hi! I have imported the app in OCI APEX workspace. The app is working fine but there are not email sent. Do you know if I have to do some setting at the APEX level instance? Thank you


Post a Comment