Report questions

[STIRRELL]

Hi,
It has been a while since I made a report in Access. I would like to create a report for expense reports that have not beencompleted. I have the data I need, but I would like to create a report with the instructions and then the detail that they employee needs to take action on. I would like to access to email the individual.

I have the basic report set up grouped on the employee email, but I am not sure how have access email the individual expense details to the employee individually. Right now the report is just one big report grouped by email .

thanks,
Sharon

 

[welshgasman]

I would have a recordset for employee.
I would process that recordset creating another recordset for expenses not completed or a Dcount() of expenses not completed.
If any exist SendObject report for uncompleted expenses to the employee email address from the employee recordset

DoCmd.SendObject method (Access)

Office VBA reference topic

docs.microsoft.com

What you have on the report is up to you?

If you have a lot of employees, then perhaps create a query to identify employees with uncompleted expenses and use that as your employee recordset.
That way you will not waste time looking at employees not affected by the logic.

The recordsource for the report could be based on employeeID, or a report can be opened filtered for an employeeID.

HTH