We have a report that will result in a number of customers (which will be broken apart via a page break) being listed. The plan is to be able to trigger a report (that will run a query) to find all loads that have not been delivered. This report will then be sent to receiving customers to let them know the status of the loads crossing the US via truck.

We want to be able to send these reports via email simply by pressing a button. No matter the fact that there will be more than one customer, we want the report (or portion of) to go to the correct customer.

We already have the customers email address in the database, but I need to figure out how to link the page of the report to the customer and have it sent.

Ideas? Solutions?