This is an A2007 that has the save as pdf add in. I think I can use the DoCmd code with acFormatPDF then save. I have very limited knowledge of VB it is the loop code that i'm not too sure about.

I have an Access report that is populated by a parameter query. I need to run the report for 250 different filters then save. How do I write a code that will run the report then save it as pdf250 times?

Jason

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.

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...