How loop through reports and email those that have an email address to the email recipient
I have a multi-page report that is grouped by an alpha field. Each group is a page by itself. I want to have a command button on a form that when clicked, will email the report to an email recipient on the report. Some of the reports don't have an email address so that report would have to be skipped. MS Outlook is the email client. I don't want to preview the report so it can be hidden.