Automating Reports

[Christopher]

I have 6 reports I want to run monthly, I have already set up the reports. I want to output all to different .pdf files inside one unique folder.


Is this possible? I know I can use the outputto function but it prompts me to change the name, but I want/some code to do this. Also, the reports prompt for input, can I set a value for this in the macro or code to fill in all prompts?

[pbaldy]

You can do this type of thing:

DoCmd.OutputTo acOutputReport, "rptBooking", acFormatPDF, "C:\" & Me.ResNum & "_" & Me.ConLastName & ".pdf"

[Christopher]

pbaldy,
I don't know what that is supposed to mean. Is that SQL code? is that something I am supposed to put into specific fields in the macro builder?

[pbaldy]

That is VBA code; I don't use macros, so I'm not sure you can do the same thing in them. Personally I'd use VBA, if you're willing to jump in.