Print report to file at Open

[Mae]

I have a report in my db that I would like to automatically have "printed" to a file. I have a macro set up that does an OpenReport that I am using in my startup options on my command line. Currently, the report prints to my default printer. Is there any way to get this to print to a file instead of the printer. My goal is to have a bat file that I can have execute a couple of times a day that will run this report and put it in a file.

This is probably more of a DOS command question than it is an Access question, but if anyone has any suggestions, I would appreciate it.

Thanks for your help.

 

[Rich]

Isn't it one of the printer options on the file>print setup ?

 

[Mae]

Yes, it is. But I am wanting to print to a file without any human intervention. I am wanting to do all of this from a bat file that I can schedule to run at certain times during the day automatically.

 

[Mae]

As I was searching for something else, I ran across mention of the OutputTo macro. This ended up being exactly what I was looking for. This macro allows you to output objects (not just a report) into different types of files. Works really great. I have set up my macro to output my report to a .doc file and I can reference this macro on my command line options in my bat file.

Thanks.