4 Replies Latest reply on Sep 5, 2013 6:11 PM by philmodjunk

    Need help with creating reports to send via email

    HelenMowers

      Title

      Need help with creating reports to send via email

      Post

           I feel like there should be a fairly simple solution, but can't seem to figure out a way to create inventory reports that are grouped by department. We have a db that has an inventory of devices assigned to users. Those users are assigned to departments. I want to be able to use the email script to send a report to each department listing the users and the multiple devices associated with that user. The problem is the send multiple emails feature will send an email for each device and the send one email will send the entire list of all users and devices to each department. Trying to figure out a way to have the script compile the records for that dept and send only those records, then loop and do that for the next department. Would appreciate any ideas! Thanks