Email Features in Oracle APEX | Sending email from Oracle APEX | Oracle APEX email Templates

Email Features in Oracle APEX: Sending an email is very important for any application to work as per business requirements. Like any other development application, Oracle APEX also provides different ways to send an email. In Oracle APEX we can send email using a Template or without a template. In both cases, you need to write code using PLSQL which is explained in the video. A sample code link is also provided below for reference or a quick start.
Download PLSQL Code:
erpstuff.com/viewtopic.php?p=...
HTML Designing:
www.w3schools.com/html/
#ERPstuff #APEX #EMAIL #Oracle

[@skamransajjad7]

Another informative video, very well sir

[@ERPstuff]

So nice of you

[@daxelai]

How to configure email in apex instance? I tried to configure but not working please make one video on it

[@ERPstuff]

Any error?

[@parthparth8680]

good video i want to generate 10 pdf file and send it by Email to customer for that where to store pdf file and how to sent it

[@ERPstuff]

You can store database in the table as BLOB column or locally in Filesystem if on-premises. thanks

[@marcdunivan2436]

Do APEX email templates support dynamic table row creation based on the input placeholder data? ( like XML XLST [transforms] ) e.g. "row1row2...."

[@ERPstuff]

Have you tried in the template?

[@marcdunivan2436]

​@@ERPstuff I see how the APEX email template can handle dynamic text. However, can it do more of an XML transform that outputs an HTML document from a datasource: ( SQL Query or PL/SQL cursor ) apply XLS transform => HTML body. Sort of like the XML

[@ERPstuff]

Hi, Better to create a sample application on apex.oracle.com and share details at [e-mail] then we can further discuss to find any possiblity. thanks

[@kanaiyasindhavad5605]

It is Possible to send email from Oracle Database version 18cxe or 21cxe on OS Windows/Linux and Apex version 18 to 22.1

[@ERPstuff]

I don't think there will be any issue in sending email have you tried? tks

[@farhanasfi_comedy]

kindly guide interactive grid records into email

[@ERPstuff]

docs.oracle.com/en/database/oracle/application-express/20.2/aeeug/downloading-emailing-interactive-grid.html#GUID-ABB06B34-A96A-4640-AAE3-6B908EB03ABC

[@reservedfurqan]

Hi, I Want to configure apex email using my gmail account, is there any setup video for apex instance.?

[@ERPstuff]

Hi, as of now no video but you will have to install certificats in wallet and ACL to allow APEX to connect to gmail. thanks

[@daxelai]

Make one video on it

[@kundenavaishnavi8977]

Can we send email using a free account?

[@ERPstuff]

Hi, what you mean by free account?

[@VirginiaRamos-ve4pd]

Can we sent email to a pool of user ids?

[@ERPstuff]

Yes sure.

[@VirginiaRamos-ve4pd]

How would you accomplish that?

[@VirginiaRamos-ve4pd]

Have a url with a pool of users, but don’t know exactly how to sent the email

[@ERPstuff]

Still your question is not clear better to write in detail at [e-mail]

[@ERPstuff]

keep list of users in the table and you can send email. what is the issue you are facing. thanks