I have a report which is sectioned by 'department'. And the output will be a pdf. So within the PDF Finance dept has 3 pages, Law has 2 pages and etc. So what I need is I need to split the report and send it to the user's email.
Splitting the report refers that the Finance part of the pdf should have 'Finance.pdf' created and emailed to Finance dept users and similarly Law should get 'Law.pdf' emailed to Law dept users.
Is there any way to achieve this? Do we have to use macros and SDK stuff to do this?
I know of a few tools like APOS which does this. But those are expensive .