Dynamic attachment to dynamic recipients / dynamic subjects :

[huhumix]

HI,

Was wondering if you could help...

We have a report ( containing a prompt)  , for example 'products'. And we want it to run for each product that meets the initial condition . So let's say we will have 2 'products' that meet the initial condition , so this would mean that we would need to produce 2 outputs for that particular report ( one output for each product).

Then we will need to send each attachment to some persons responsible, but we will need to have the product name ( that is also in the attachment)  in the subject field and in the message body ( as we will have also a message in the message body, apart from the attachment).


I created the condition, then a 'Run a report task' and after that the 'Send an e-mail' task . I manage to run the report and send to all recipients but :

a. i put the target report prompt to be multiselect ( because when i used single select, it ran only for the first value.. and remember, i had 2 values for which to run). This way i got a report containing both values, but not 2 reports containing a value each.. how to fix that ?

b. because i put the 'product' data item in the subject of the e-mail, it send out 2 e-mails ( one for each product), but having , of course,, the same attachment ( the one containing both)...

The ideal thing would be to send one email for each product, containing the attachment for that particular product :)) i don;t think it's possible, as the E-mail task needs to know the parameter selected in the previous task ( 'Run a report')..

Any ideas are welcomed :)