Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Always mail Send with info@abc.com in FROM Clause

VedantMay 23 2011 — edited May 24 2011
Dear Sir,

i am using Email Option in my Application mail are send Successfully but all mail are sent from info@abc.com
DECLARE

l_id number;
to_add varchar2(1000):=:P1_TO; 
from_add varchar2(1000);
l_body varchar2(4000):=:P1_DESCRIPTION;
l_sub varchar2(1000):=:P1_SUBJECT;

BEGIN

   select email_id into from_add from user_master where user_id=:app_user;  

   l_id:=APEX_MAIL.SEND(
        p_to        => to_add, -- change to your email address
        p_from      => from_add,
        p_body      => l_body,
        P_subj      => l_sub);

         

  COMMIT;
apex_mail.push_queue(
P_SMTP_HOSTNAME => '102.111.0.9',
P_SMTP_PORTNO => 25);
commit; 

END;
select email_id into from_add from user_master where user_id=:app_user;

i am using this to extract EMAIl ID with respective user Email id is come correct but when i send email then it send from info@abc.com



How can i send email with user email id.


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2011
Added on May 23 2011
4 comments
746 views