13 Replies Latest reply: Oct 22, 2013 3:07 AM by jariola RSS

    Apex 4.0 sending email

    raghav1212

      Hi ,

       

      I have a email process which runs on clicking on send button . I am getting mail sent success message but not received mail into mail box ? any suggestions below is the process i am using . And i configured email settings at apex admin page.

       

      DECLARE

       

       

        v_subject    VARCHAR2(100);

        v_sender     VARCHAR2(100);

        v_recipient  VARCHAR2(100);

        v_cc         VARCHAR2(100);

        v_bcc        VARCHAR2(100);

        v_body       VARCHAR2(4000);

        v_body_html  VARCHAR2(4000);

       

       

      BEGIN

       

       

        v_subject   := 'Email Subject';

        v_sender    := 'r4rare@gmail.com';

        v_recipient := 'raghub1212@gmail.com';

        v_cc        := '';

        v_bcc       := '';

       

       

        v_body      :=  'Some text' || chr(10) || 'more text here';

        v_body_html := 'Some text<br />more text here';

       

       

        -- Send plain text email

        APEX_MAIL.SEND(

          P_TO       => v_recipient,

          P_FROM     => v_sender,

          P_CC       => v_cc,

          P_BCC      => v_bcc,

          P_SUBJ     => v_subject,

          P_BODY     => v_body);

       

       

        -- Send HTML email

        APEX_MAIL.SEND(

          P_TO        => v_recipient,

          P_FROM      => v_sender,

          P_CC        => v_cc,

          P_BCC       => v_bcc,

          P_SUBJ      => v_subject,

          P_BODY      => v_body,

          P_BODY_HTML => v_body_html);

       

       

      END;

       

      Thanks

      Raghav