How do I exicute and save a report with parameters in Acess 2007 to pdf files?

[jmborron]

I have a report in Access 2007 that is populated by a parameter query. My boss wants this report ran for all 250 optoins once a month, saved as a pdf and emailed to the contacts located in a table in access. I have tried using docmd.sendobjec t but it will not work with my companies Groupwise email.

Does anyone have any suggestions on how I can either write a code with loop that will exicute the report for each option and save as pdf (I have downloaded the save as pdf add on of Acess 2007)or would be even better if someone had an idea how to get Access to work with our groupwise.

I'm assuming there is a way to query the required parameter run a report then loop back to the next selection all 250 times.

Thanks

Jason

[munkee]

Jason,

It just so happens I was talking to a friend who was doing something similar the other day (different company). He managed to get the email working using one of the classes found here:

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

I havent used them myself but hopefully this will point you partially in the right direction.

[jmborron]

I found a code that will work with GW i'm still at a loss on how to make the report loop through all 250 options.