+6We have created an event that will email the customer statement of account when a report has been run.
I have concerns about the number of messages that will be generated and sent when this is run.
Has anyone used a bulk mailer system process these messages? The next question is how to export the individual messages so they can be transferred to the mailer service.
+2Step-1 - Define a report rule to fire an e-mail when a report is executed (here you can pick email id dynamically based on customer contact or supplier contact or employee)
Step-2 - Execute the report using PLSQL Code say looping each Customer (as a Custom Menu or Quick Report or from a PLSQL tool)
Multiple report execution happens and the RRE fires multiple e-mails. These are background queued jobs and hence should not choke other processes (if you allocate a dedicated process)
I have a problem with the bulk send, having multiple crystal failures when producing a large number of reports.
Quite like the idea of executing the report in pl/sql with a loop to ensure jobs run 1 at a time but my pl/sql skills are lacking. Would prefer to use custom menu. Do you have an example of the code needed?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
