Sending personalized reports to individual Email (1 Viewer)

I have a access database where reports generate individually by Vendors . So each vendors has some detailed information on a page including the email address and then next page shows the next vendor 's details. Currently, I have to email this whole report to a number of users. So I need a solution which is somehow automated so that each vendor get their email with their individual page of the report.

I'm not an Access expert, I just generally use it for data manipulation with queries, so Access reporting is all new to me. Many thanks in advance, if you can assist.
Its the best I can explain this, so I'm hoping you guys can help me.

You will need to loop through the users in turn. In each case, filter the report as appropriate for each user then email as an attachment.

This has been asked several times on this site.
One such request I have found is https://www.access-programmers.co.uk/forums/showthread.php?t=200225

See the link in post #2