Report Loop and Automated E-mail Notifications

[CODy]

I am trying to set up a button in access that automatically generates individualized (by customer ID #) reports of customer payments, and e-mails the customer their specific report.



Are there step by step guides for setting up the report loop and associated e-mail function?

Definetely new to VB, so I need the basics for this.

Any help appreciated.

thanks-

[ranman256]

DoCmd.SendObject acSendReport, "rReport", acFormatXLS, vTo, , , vSubj, vMsg

If you F1 on SENDOBJECT , help will also give you more code on outlook email.

[pbaldy]

This and the looping code referenced should help:

http://www.granite.ab.ca/access/emai...recipients.htm