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
- 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 firstname.lastname@example.org, email@example.com John Doe <firstname.lastname@example.org>, Jane Doe <email@example.com> &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.