1 person found this helpful
A) from within a form - add procedure of type "Send_email" and use substitutions/placeholders like &P1_NAME. or &P1_EMAIL. in the UI properties... - this is one email as per page/data
B) loop thru records of a table and send emails to those records like: - this is: several emails in a row....
FOR m IN (SELECT VORNAME, NACHNAME, EMAIL FROM TABLE Where email is not null and status = 'Aktiv' and ABTEILUNG like '%'||:P3_ABTEILUNG ) LOOP apex_mail.send( p_to => m.EMAIL, p_from => 'info@my_email.de', p_bcc => 'info2@my_2nd_email.com', p_body => 'Hallo '||m.vorname||','||chr(10)||chr(10)||:P3_TEXT||chr(10)|| :P3_SIGNATURE , p_subj => :P3_SUBJECT ); end loop;
:P3_TEXT, :P3_SIGNATURE, :P3_SUBJECT and :P3_ABTEILUNG are names of fields in page 3 - in SQL and pl/sql these types of substitutions are used... in the Procedure re A) "Send_email" UI we use substitutions of type: &P3_NAME.
Hope that helps