Has anyone found a way to have a query automatically run and email the results everyday?
Our sales teams wants to see what orders have been shipped for the previous 7 days and have it in their email each morning. I have written the query, but haven't figured out how to have it automatically execute and send.
They also want a report that shows their bookings for the Month to Date and they want that emailed every Monday morning to them. I haven't been able to find anything that is real good from a Sales person perspective in existing reports. Has anyone written anything?