Sending an Email from an Oracle Apex Application

Done it ..

1. Here is the customer feedback form – customer enters feedback text and presses submit feedback button

feedbackform

2. In the Action When Button Clicked section, set Action value equal to Defined by Dynamic Action

3. Create a Dynamic Action. In the When section set the following values:

Event: Click

Selection Type: Button

Button: SUBMIT (Submit Feedback)

4. Add a TRUE Action

5. Set Action=Execute PL/SQL code

6. Under Settings, add the following PL/SQL code (Note p-body has been assigned the feedback bind variable :P102_FEEDBACK so that whatever text is entered by the customer will be sent in the email

BEGIN
apex_mail.send(  p_to       => ‘receiver.co.uk’,   — change to your email address
p_from     => ‘sender.co.uk’, — change to a real senders email address
p_body     => :P102_FEEDBACK,         p_subj     => ‘My Plain text message’);
END;

7. Run the page. Add some feedback and press the submit feedback button.

8. Voila! Within seconds you should receive the email in your email inbox

Job Done.

Keep Experimenting – it is the best way to learn

Advertisements

One thought on “Sending an Email from an Oracle Apex Application

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s