By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

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

P: 4
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.sendobject 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
Aug 19 '10 #1

✓ answered by 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/emai...lgroupwise.htm

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

Share this Question
Share on Google+
2 Replies


100+
P: 374
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/emai...lgroupwise.htm

I havent used them myself but hopefully this will point you partially in the right direction.
Aug 19 '10 #2

P: 4
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.
Aug 19 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.