Export a report in RTF

[Never4Get]

I've created VB-code which reads several tables and generates different reports according to the values in the tables. I can print each report before the next one is generated, but actually those reports should be saved in an RTF format. How can I export these reports using VB-code.

 

[shacket]

Look at the OutputTo method of DoCmd

 

[Talismanic]

You can use the SendObject to do it like this:

DoCmd.SendObject acReport, "ReportName", "RichTextFormat(*.rtf)", "YourEmail", , , _
"OptionalSubject", "OptionalText", True

Let me know if this won't work for you or if you absolutely have to use a transfer in place of the SendObject. I might be able to come up with something else.

 

[shacket]

SendObject will send the report as an attachment to an e-mail. OutputTo will save it to the computer. Use the one that best suits what you are trying to do.