Scheduled Report Email Addresses

michaelmassey
Giga Contributor

I have created a report that I want to schedule. Creating the report and scheduling is working fine, but I want to create a dynamic list of Email Addresses to send the report to each time it runs. I am trying to put javascript in the Email Addresses field on the Scheduled Email of Report record but it does not seem to work. Has anyone used this field and then called a Script Includes to build a dynamic list of email addresses? Is there another way of scheduling the report and creating a dynamic list of email addresses to send it to? Thanks.

8 REPLIES 8

Wesley Breshear
Tera Expert

Very similar to Michael's request.   I would like to create a dynamic email list each time the report is schedule to run and email those users that are part of the report and include a static list of users as well.   This would be for a weekly Change Management report.   Users are unique each week that have placed a Change Request into the system, there names are associated to the change request. So a script that pulls their email address from the report, applies all them to the "Email Address" field, or adds their User Name to the "Users" list of the Schedule Report. Then email everyone, so each change request can be reviewed by all the regular CAB members (static) and all the Change Request-ors (dynamic).



Anyone seen this done yet, provide an article showing how to extract names from a List report and applying them to the "To:" field of the scheduled report?



Thanks!


-Wesley


Hello



Have you found how to implement that, im trying to implement a similar solution that create a recipient list only if a specific hardware have a specific status.



Regards,



Christophe Silva


Hi Christopher,



No luck.   Still a manual process for us.



Regards,



Wesley


Hi Wesley,



You might have already found a solution for this as it's almost an year. Would suggest to have a look at below thread if you are still using the manual process.



HELP! How to dynamically set recipients of an existing Scheduled Report to email addresses that are ...  



Regards


SK