Well the easiest way would be to send an email for each record?
The tidiest way IMO would be to send one email for ALL the items for a particular destination?
For that you need to sort in the correct order and then only send when the destination address/user changes.?
Here is something I used in one of my DBs.
Probably more than you need as I used html emails, but it should get you started.?
OK, could not paste, complains about more than 10K characters.
Attach method seems to have changed as well (not for the better BTW

)
Also look at
https://www.youtube.com/results?search_query=send+emails+with+attachments+from+access+database