Is there a way to pause the sending of mail in Apex. We are trying to send a bulk message in such a way that there is no time lapse between the time the first message is sent from Apex to the time the last message is sent.
So the process would look something thing like this..
Each message will have a unique identifier to determine who responded so we cannot BCC.
CREATE PROCEDURE SEND_EMAIL
.............................
..................................
--
SELECT EMAIL_ADDRESS BULK COLLECT INTO V_EMAIL_ADDRESS FROM TABLE;
for i in v_email_address.FIRST .. v_email_address.LAST Loop
apex_mail.send( P_TO => v_email_address(i),
....mail details);
SOME FUNCTION OR PROCESS TO HOLD ALL THESE MESSAGES IN QUEUE (This is what we need)
END LOOP;
-- RELEASE ALL MESSAGES IN QUEUE AT THE SAME TIME
Apex_mail.Push_Queue();
.....
End;
Is this possible? Thank you!