Emailing a Report (1 Viewer)

I have a table called "Applicants" which lists applicant names, email addresses, and property assigned. I want to add a button to my form which will automatically email a report to all applicants with the same "property assigned". I'm not very good at VBA so I've been using the "Create Macro" tool and have only been able to get it to send to the 1st record found in the table instead of all of the records with the same "property assigned". Any ideas?

I admit, I never use the macro tool. VBA might have a steeper learning curve, but its flexibility and ability is far superior than anything you can create in a macro.

Also it sounds like you are stuck in the first record of a loop scenario. I honestly don't even know if loops are possible in a macro, but if they are, that is what you need.