BI Publisher to Burst Email with Multiple Attachments
Hello all.
Let's assume the imaginary scenario below.
Sales Manager | Sales Person | Brand | Revenue |
---|---|---|---|
Joe | David | Toyota | 10,000 |
Joe | Eddie | Toyota | 11,000 |
Mark | Susan | Honda | 6,000 |
Mark | Charlie | Ford | 5,000 |
Mark | Ted | Audi | 15,000 |
Based on above scenario, I want BI Publisher to burst an email to Joe, containing two files, each for David and Eddie, listing their sales performance. At the same time, another email goes to Mark, with three files, each for Susan, Charlie, and Ted.
I wonder if the Split By and Deliver By will be the answer to this, since I've tried playing with those two, but still not successful in achieving the above requirement. Any idea how to achieve this?