Output Multiple Reports to PDF

[Jaimito01]

I need a code to be able to output several reports to several pdf files.
The source of the reports are 30 queries identified with numbers 1 to 30.
I need to email this reports so I just don't want to print the reports to pdf but output them to a file. If I have the email addresses of where each of these 30 reports should go to in a table, can I include the email address in the routine?

 

[Remou]

Have you tried a search? There is quite a bit on outputting reports to PDFs and email.

 

[Jaimito01]

Yes I have tried, but can't find nothing similar, even though I think it is something a lot people might have been faced with.
I actually need to automote the SEND OBJECT (in PDF) with VBA loop, buy don't know now.

 

[Remou]

Unless you have Access 2007, that will not be possible. You need to print using a PDF printer and automation on, say, Outlook or CDO. The details will depend on your set-up, but here is one example:

http://www.tek-tips.com/faqs.cfm?fid=1635

and more:

http://www.lebans.com/reporttopdf.htm

Here is something on email:

http://www.tek-tips.com/faqs.cfm?fid=2823

Ans so on.

 

[Jaimito01]

I was thinking something more of in these terms:

A code that will loop 30 times that will send 30 individual reports converted to pdf (it can be XLS output format too) by email to 30 different recipients whose email addresses are stored in a table with numbers 1 to 30. Each report is named 1 to 30 too.

 

[Remou]

The very first item of a search "SendObject loop" returns this:

http://www.tek-tips.com/viewthread.cfm?qid=1497623&page=12

In Tek-Tips we like to see a little code from the poster, be it ever so little.