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