Help with automated per-record report distribution

[tb1150]

Hi all, first post here.
I am looking for some help regarding automated per-record report distribution. In my system there is a report generated with a record for every person that must be sent out to them on a periodic basis. Ideally I would like to send them out in batch(5000+ records) so that each person receives theirs via E-mail. I am not too worried about the format. Each persons record contains their E-mail address so that should make things easier.


I appreciate any help you can offer.

[ranman256]

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.

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

[tb1150]

Thank you mate! Is exactly what I am looking for