This content has been marked as final. Show 5 replies
Gor_Mahia wrote:Where did you come across about that limitation? There is no such limitation in built-in send email process and you can send it to multiple recipients with multiple attachments.
I want to create email page but the email process type within Apex seems to be having some limitation i want to have multiple receivers/recipients, attachments etc. What is the best and most preferred approach? i searched "Application Express Builder User Guide" talking about customizing APEX_MAIL but explanation is not detailed enough,
Apex 4.1.1/Oracle 11g2
When you are creating the send email page process please click on labels to get more help and this is what it says:
- To field
- Attachment SQL field
Valid email address to which the email will be sent. For multiple email addresses, use a comma-separated list. Use substitution syntax if you want to use a dynamic value. Examples email@example.com, firstname.lastname@example.org John Doe <email@example.com>, Jane Doe <firstname.lastname@example.org> &P6_TO.
Alternatively you can also create a pls/sql process manually to do the same invoking the APEX_MAIL API
SQL statement which returns one or more BLOBs which get attached as files to the e-mail. The SQL statement has to be in the following format: select blob_column, file_name, mime_type from table The column mime_type is optional.
Will do asap and close if possible. Thanks again for such helpful suggestion.
I instead decided to use custom mail send process as below. I did some test and it works great but at times it throws the below error,
ORA-29279: SMTP permanent error: 503 5.0.0 Need RCPT (recipient)
but i know for sure the recipient emails are all correct, any idea what could be wrong here ?
vEmail := :Pxxx_TO_MAIL;
v_subject := :Pxxx_SUBJECT;
v_sender := :Pxxx_EMAIL;
v_recipient := vEmail;
v_cc := '';
v_bcc := '';
v_body := :Pxxx_TEXT;
v_body_html := 'welcome to the world.';
P_TO => v_recipient,
P_FROM => v_sender,
P_CC => v_cc,
P_BCC => v_bcc,
P_BODY => v_body,
P_SUBJ => v_subject);
Hi,1 person found this helpful
ORA-29279: SMTP permanent error: 503 5.0.0 Need RCPT (recipient)You will get this error then the v_recipient is null in this line
P_TO => v_recipient,
That was helpful but i resolved it the format of the emails wasnt right...thanks.