Search results

Great thanks. I'll need to send emails via Outlook, and if you have the code available for that then even better. Really appreciate your help.

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...

I tried this but it went straight to the error handler DoCmd.OpenReport "rptDebtorStatement", acViewPreview, , "[CustomerID] = '" & lngCustID & "'"

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...

First post. I'm an Access technical user with a small number of clients but frequent questions!