Emailing a recordset

[prmitchell]

How do I email a recordset to an email address contained in the recordset - as a report or query - using Outlook as the application?
Example of the recordset

email	FirstName	SportName	SportDate	ActivityName	ActivityDate
volunteer1001@gmail.com	Peter	Lawn Bowls	15/10/2021​	Oct Dinner	23/10/2021​

 

[Ranman256]

docmd.SendObject acSendQuery ,"qsMyQuery",acFormatXLS,sTO, ,,sSubj, sBodyMsg