I have a form with a list box of users, emails.
The button will then scan the list , send email to each individual,and attach the query. The query uses the form user list, to generate the data.
So you need a userID field or something (We used STATE) to divide the data amounst the users.
As the code goes thru the users list, the query sees the user and pulls THAT users data.
Code:
dim vEmail
for u = 0 to lstUsers.listcount - 1
lstUser = lstUsers.item(u)
vEmail = lstUser.column(2)
docmd.SendObject acSendQuery ,query,acformatxls,vEmail ,,,subj,msg
next