I have a need to email out a Sales Recap on a daily basis to about 17 different Sales Reps. I have all my saved searches created, they are displaying the correct results, but when it comes down to emailing it out at 4AM it is only emailing a percentage of their delivered orders for the day.

When i go back to the search and display results it’s all there. When I manually generate a PDF, it looks great. But why does it not email all the results when it is scheduled?

I found out that if it’s taking too long to pull the search it will quit and move on to the next scheduled search so I added extra time in between each scheduled search. I first tried 5 minutes, then tried 10 minutes apart, and it is still not emailing all the results.

Any suggestions?

Edit: No matter what format i choose (PDF, CSV, Email body) the results are capped. The largest single sales rep report could be up to 1000 lines but the average is anywhere from 100-500 lines on any day.