Access Export Automation

[khays]

Does anyone know how to write VBA code to automate exporting a report into an .rtf file with the path/filename automatically?

 

[SgtJarrow]

Here is what I use.....strTrustee is a variable naming the report object in Access (rptTrusteeInvoice), and strSavetrusteeInvoices is the actual report name in Windows (Trustee Invoices.rtf). You could use anything else or even "hard" code it.

DoCmd.OutputTo acOutputReport, strTrustee, acFormatRTF, "H:\Billing\CTIL Billing\" & strSaveTrusteeInvoices

Hope this helps.
Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com

 

[khays]

Thanks,

 

[khays]

Thanks,