In Publisher, you can loop a field to distribute by email to different users even without reducing data, if that's the case. The only thing you need is to include those email addresses in the script using any valid source (INLINE, excel file, database table...). You only need one task to do that, instead of creating as many tasks as possible recipients.
Hope that helps.
Miguel,Thanks for your timings
actually,I have added the mail ids in an excel and called those inside the application and its working fine but my problem is to generate individual pdf to individual region in a single task?
although if I loop and band the field "Region",I can still be able to see all the Regions in my report :-(
eg of my scenario:
Region Email Address
My Requirement :
I need to send as Region1.pdf to email1 and
Region2.pdf to email2 after each reload with out creating 2 different tasks
Try this in the task:
- Set Reduce by Region, using "Reduce By Field Value".
- Use the "Reduced Document Name" textbox to configure the name of the report (for example, using the value of the field Region).
- Then go to the tab "Distribute" in the same task, select "Loop Field in Document", click on "Open Document" and select your field "Email Address" and set "Check user identity on" "Email Address", and click on "Target Type:" "E-Mail".
- Finally, in File Type, click on "PDF Report from Source Document" and select the report ID you want to send by emailfrom your QVW.
Apply to save settings and run the task: it should reload first, then reduce and create as many PDF files as regions and recipients, then send them by email, in the same task.
Hope that helps.
When i tried what you suggested,Iam getting a warning as below:
"Warning : Dynamic distribution returned no receipients using "EmailAddress" using parameter "EmailAddress"
actually I kept all the email_id's under the column "EmailAddress" in the excel and called this inside the application
do i need to change some thing in the email column,pleae do let me know