Automate emailing reports?

[calculating additional data help]

Hello,

I have several reports in Access that I would like to automate emailing to a
distribution list in Outlook, but not sure how to do it.

The reports are from a query so data should reflect up-to-date which do not
require refreshing like in Excel pivot table.

Any help is appreciated.

 

[Mark Andrews]

Get the email addresses into the database and use
http://www.rptsoftware.com/products/email
(many examples of code in demo)

or
write a way to loop through recordsets and create reports and send them
using sendobject or an smtp component

Here's an article about how to access an Outlook distribution list from
Word, it might help:
http://www.slovaktech.com/code_samples.htm#DLToWord

HTH,
Mark



"calculating additional data help"