Oracle Communities

Oracle Analytics and AI

Child Item

How to send multiple files from "split by" in one email by "deliver by" ?

Bursting a report we want to send every invoice, dunning, etc as a separate PDF/Excel, but in one email per customer .
I thought this could be done by configuring the "Split by Invoice#" and the "deliver by Customer#" - but there are always sent separate mails for every Invoice-PDF, so if there are 5 Invoice# the customer gets 5 emails 🤨

Any help is appreciated!

Thanks,

Dirk

Find more posts tagged with

Accepted answers

Bursting will only send one attachment per email.

The attachment can have multiple records, such as 5 invoices in one file.

Rgds,

Kevin

All comments

https://community.oracle.com/products/oracleanalytics/discussion/27956/how-to-send-multiple-files-from-split-by-in-one-email-by-deliver-by

Hi Dirk,

So, you want 5 different PDFs to be attached and sent as a single email?

Thanks.

Following up, what is the KEY attribute value that you have used in your bursting definition?

Hi Mandeep,

the KEY is defined as related to the customer no which is the "deliver by" property.

Thanks,
Dirk

https://community.oracle.com/products/oracleanalytics/discussion/comment/74024#Comment_74024

Any new ideas, Mandeep?

Bursting will only send one attachment per email.

The attachment can have multiple records, such as 5 invoices in one file.

Rgds,

Kevin

https://community.oracle.com/products/oracleanalytics/discussion/comment/74077#Comment_74077

Hi Kevin,
thank you for clarifying the matter.

Regards,
Dirk