B
buster_brown234
Hi,
I am wondering if there is a way of exporting a report to
the windows clipboard. We use a database to collect
information that needs to be sent by fax - however office
applications do not have access to the fax server. Only
our custom built software can send faxes.
At the moment I am using a rather round-about way of
exporting the report to word, and relying on the operator
to ctrl+a then ctrl+c to copy to clipboard, then ctrl+v to
paste into our messaging software -
Private Sub Command62_Click()
DoCmd.Echo False
DoCmd.OpenReport "MarepReport",acViewPreview,
"QueryPrintExistingRecord"
DoCmd.OutputTo acSendReport, "MarepReport",
acFormatRTF, "S:\Marep\MAREP
DATABASE\MarepTextFile\MarepReport.RTF", True
DoCmd.Close acReport, "MarepReport"
DoCmd.Echo True
End Sub
Anybody and thoughts?
Any help appreciated.
I am wondering if there is a way of exporting a report to
the windows clipboard. We use a database to collect
information that needs to be sent by fax - however office
applications do not have access to the fax server. Only
our custom built software can send faxes.
At the moment I am using a rather round-about way of
exporting the report to word, and relying on the operator
to ctrl+a then ctrl+c to copy to clipboard, then ctrl+v to
paste into our messaging software -
Private Sub Command62_Click()
DoCmd.Echo False
DoCmd.OpenReport "MarepReport",acViewPreview,
"QueryPrintExistingRecord"
DoCmd.OutputTo acSendReport, "MarepReport",
acFormatRTF, "S:\Marep\MAREP
DATABASE\MarepTextFile\MarepReport.RTF", True
DoCmd.Close acReport, "MarepReport"
DoCmd.Echo True
End Sub
Anybody and thoughts?
Any help appreciated.