Thank you so much HiTechCoach, this is excellent and gives me everything I need for adapting to my database question. I can include code to send each report in turn to Outlook, picking up the recipient email address from the form.
I'd happily give you a star rating if there's a way of doing it!
Thanks for latest reply which appeared as I was typing. Unfortunately I have to leave this for a few hours but will return after trying your suggestions.
Thanks all, things to try.
The bigger picture is that the Statements report currently includes every customer. Their owings appear on individual pages and my client prints them all then sends individual ones by post. Some people now prefer emailed copies of their reports.
My first procedure...
To start this process I have a procedure to generate a set of Customer IDs within a date range; this correctly retrieves the ones needed. I want it then to pass each Customer ID to another Test procedure to generate a report.
Private Sub cmdEmailRequested_Click()
Dim dbs As DAO.Database
Dim...
I currently have a report for Debtors that lists everyone currently owing money. The report is based on qryDebtors and contains many Customers and details of each of their unpaid invoices. The date range to be applied is selected from a general form frmSales.
The report has so far been...