You have to loop through the recordset that makes up the report (assuming it contains the email addresses) and in that loop, execute the email code. If the report recordset doesn't contain the email addresses, then you need to add that to the report recordset (you don't have to show the addresses) OR query to get the addresses based on who will appear in the report and base the sending code on that. If you want to send report details that only pertain to a particular user, then that is a different situation.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.