how to make an excel file and export it to mail (1 Viewer)

[mana]

Hello

i want to make an excel file from a query and then export it to mail. can you guide me please how to do this?
i want to make an excel and then send it as an attachhment.
also i want to insert the mail address to manually
because each time it is sent to a different person.
thank you

 

[Ranman256]

DoCmd.SendObject acSendQuery, "qsQuery", acFormatXLS, "name@aol.com", , , "Subject", "message"

if you build a listbox of email names , then scan the list , the query can read the list and send only that person's data.

  'scan items in listbox
For i = 0 To lstClients.ListCount - 1
   vTo = lstClients.ItemData(i)
   lstClients = vTo
        
   DoCmd.SendObject acSendQuery, "qsQuery", acFormatXLS, vTO, , , "Subject", "message"
next

 

[mana]

hello
thank you for your help
but i want to fill out the email address manually
and without message
is it possible in this way as well?