need to send reports via Outlook 07

[ROMADOZ]

All,
I am not a programmer, but I do know access can send reports via email if I can get the code right. I have a training db. I need to send reports out automatically at a set interval as attachments. I am running Office 07 all around. I have my reports tied to a query tied to a combo box on a form. I pick the name and hit the "run report button" and tada... report by person. I need the individual reports to be sent to the individuals and their supervisors. I have 2 fields on my personal info talble for the email addresses and a query for them... and thus ends my understanding. Help?

-ROMADOZ

 

[bjsteyn]

Hey there, i'm also looking to do something similar . I would like to send invoices as attachments. But using office 2003. Anybody with a code fix. Thanks bj

 

[pbaldy]

Here's a start:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm